[RESOLVED] Unique id retrival

[chrisleon]

Is there an easier way to retrieve the unique id assigned by mysql after an insert of a record.

Unique id is a column with created with primary key, not null, auto increment

I am currently inserting the record, and afterwards running another query that returns the top 1 row descending. This maybe incredibly chicken sh%^ but its all I ever learned to use.

If there is a better way to do an insert and know what the unique id assigned is, I would love to find out.

Thanks

[NogDog]

[man]mysql_insert_id/man or mysqli_insert_id(), depending on which interface you are using.

[chrisleon]

thank you, I had no idea that was even out there