I have a table "Members" with the following 3 fields: userid (int, primary key, auto_increment), email and name.

I use the following line to enter members in the table:

$results = mysql_query("INSERT INTO Members (email,name) VALUES ('$email','$name')");

I never specify the value of the userid field, this is done automatically. But is there a way to know what userid a member received without doing a database search? I need this userid value to enter in another table that contains all the input of the new member.