user management

[morrisoner]

hi ive got a simple database with a users table. A HTML form to sign up to the users table. And a PHP script to input the data into the database. In the data I have a field userID that is the primary key and automatically increases when a new user is added.

When a new user signs up how can i tell the user what their userID is automatically?

[Mordecai]

$result = mysql_query('SELECT id FROM users WHERE username="$username"');
while ($userinfo = mysql_fetch_array($result,MYSQL_NUM)) {
$id = $userinfo[0];
}
echo($id);

[morrisoner]

this would require a unique username yes?

[Mordecai]

Yeah.