PHP help

[Luke]

Hey

Right, I need to some regarding a 'register' form.
I currently have a login, and the "username" is the "id" on the users table.

So when they regsiter, i just want them to enter password, email, name and then it says:

"Thank you Bob Smith, your userID is xxxx, you may now login with the password you chose"
I know how to insert the data into the database, but not show the last bit, not sure how to grab the ID of which has just been created for the user if you get me?

+rep to help

Cheers
Luke

[Luke]

Update: Got it. Closed.