Janet Valade wrote:
Jeff wrote:
Is there a way to get the last Record # created by the DB.
...
what code could I add here to make the following line work?
echo "REMEMBER your USER ID# you will need it when creating
Characters!! It is: $user_id"; <----- I want to show the "user_id"
just created here.
Thanks in advance!
The function mysql_insert_id will return the previous id inserted.
http://us3.php.net/manual/en/function.mysql-insert-id.php
Janet
but to use this, you need to have the user_id field name and value
omitted from the insert statement.
Other wise it enters a null value in the field, basically overriding
the purpose of the auto_increment setting.
Once you have completed the the insert,
run this command
http://www.php.net/mysql_insert_id
This will then give you the LAST INSERT ID for your connection to the DB.
Hope it helps
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
