Page 1 of 1

Capture auto_increment number

Posted: Wed May 25, 2005 10:05 am
by abshaw
I have a php code inserting into a mysql database, the table has a primary key which is auto_increment.

Now when a new record is being added it is not know what id will be assigned to the record as it depends when the form is submitted.

but once the form is submitted i want to capture the id assiged to the current record and then display

<? php
echo "Thankyou, Information on file number $f_id has been successfully added."

?>

any sugesstions?

Posted: Wed May 25, 2005 10:16 am
by JayBird

Posted: Wed May 25, 2005 11:23 am
by abshaw
great, works like a charm.