[RESOLVED] Retrieving a record atfer insert

[davidjames52]

Hi all,

Is there any way that you can retieve a value from a record that you have just inserted into mysql database. I am inserting a record and have a auto number column. What I need to do is get that number after I have inserted the new record and then echo it out onto the screen.

Thanks heaps.

[dalecosp]

Yes. Try [man]mysql_insert_id/man.