Get current id from MySQL post/query?

Hi Experts!

In the same PHP file I want to:

1. I want to create a new user and post it to the database (that code is already created)

2. echo the user id for that new user.

How can I do that?

I could find out the highest user id from the database and echo that, but it doesnt feel 100% safe.

Is there a way to find out the "current" id that was posted at that moment?

Thanks in advice!
LVL 3
GodDoesntExistAsked:
Who is Participating?
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
presuming that your table has auto_increment, learn about the LAST_INSERT_ID() function of mysql:
http://dev.mysql.com/doc/refman/5.0/en/getting-unique-id.html

resp: the php shortcut function mysql_insert_id:
http://lu2.php.net/mysql_insert_id

that's 100% safe.
0
 
GodDoesntExistAuthor Commented:
Thank you!

Perfect solution!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.