Posted by Christoph Burschka on 03/26/07 18:27

Tom wrote:
> 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

It retrieves the *last* id that was inserted - apparently he wants to look ahead
to find the one that the next entry will be inserted with.

[Back to original message]