mysql auto increment

[Anon]

I am using a mysql table with a field rec_id which is set to auto increment. I need the value of rec_id after I insert a new record. Is there a way to do this without actually doing a select statement after the insert.

i.e. is there a way to get the value of rec_id directly from the insert.

[Anon]

why didnt you actually READ the php documentation regarding mysql function before start panicking ?

mysql_insert_id is your friend

[Anon]

Another way is to create the query something like "INSERT into TABLE_NAME VALUES(other_table_id=LAST_INSERT_ID(),column2='value2')"
I've not used this in a heavy-load server environment yet, but I believe it keeps the last insert id for your specific session (i.e. another user performing an insert between your 1st and 2nd query will not pollute the 2nd query).

[Anon]

Simple.
Do this:

Select MAX(auto_id) from your_table

The MAX value will contain the auto number you're looking for =)

[Anon]

he did'nt what to use two queries! anyway doing the MAX() function is not a good option on a multiuser application as more than one field may be getting added at once - so you may get the wrong ID returned !

a wee bit late but it had to be said...