relative sql table ID question how to echo ID variable after executed

[iBuddy]

Alright I have a question that is hard to explain. I have a registration form. After the user submits the information I want it to show the ID (which is my first column in my table that auto increases) I tried to do like echo $myrow[0]; but that dont work too well. Anyone help?

[bastien]

do a select from the table where the info is what was just entered..then show the id

[tasistro]

// code used to insert record here

$id=mysql_insert_id();

// $id now hold the value of the id (primary key) of the last insert

look into mysql_inser_id();