Posted by Tom on 03/21/07 18:46

On 18 Mar 2007 23:22:29 -0700, Michael wrote...
>
>I know this is probablly really, really simple, but I can't figure out
>how to retreive the next autoindex in a table, so when I want to
>obtain it, I've been inserting a new row, then finding the unique
>index from some combination of other values that I know will be
>unique.
>
>So I would appreciate you're help in this regard:
>1. What's the appropriate SQL query to get the next autoindex from a
>table (say 'user').
>2. How do I obtain that value in PHP (as in, what would I use as the
>index in the array returned by mysql_fetch_assoc())
>
>Thanks!
>

I think the "mysql_insert_id()" function does that...

http://us2.php.net/manual/en/function.mysql-insert-id.php

Tom
--
Newsguy.com
Basic Accounts $39.95 / 12 months
http://newsguy.com/overview.htm

[Back to original message]