Get ID of the record just added [SOLVED]
Posted: Wed Nov 17, 2004 8:19 am
Hi all,
I'm doing a simple record insert into my MySQL table and immediatly after the record is added I want to use the auto-incremented ID column of the table
How do I get the ID of the record I just created?
I thought about selecting the very last record in the table but this could be dangerous if I have several users all hitting the submit button at the same time.
Could a little advice be offered?
(Yes I know don't eat yellow snow...yadda yadda yadda...you funny blighters)
I'm doing a simple record insert into my MySQL table and immediatly after the record is added I want to use the auto-incremented ID column of the table
How do I get the ID of the record I just created?
I thought about selecting the very last record in the table but this could be dangerous if I have several users all hitting the submit button at the same time.
Could a little advice be offered?
(Yes I know don't eat yellow snow...yadda yadda yadda...you funny blighters)