[RESOLVED] Get autoid from another table

[jasondavis]

My code below inserts a new user into my database, before email though there is an autoid that is created, what I want to do is insert the same autoid,email,password into there own table, I was told this is better performance, so my trouble is I do not know how to have it insert another entry and get the 1st tables autoid number

$insert = "INSERT INTO friend_reg_user (email, username, fname, lname, password, country, zip, city, gender, dob, disp_name, submit_date, uniqid, status,usstate,othstate,IP_ADD) VALUES ('$email', '$username', '$fname', '$lname', '$password_temp', '$country', '$zip', '$city', '$gender', '$dob', '$fname', now(), '$uniqid', '$active','$usstate','$othstate','$LOCALIP')";
				executeQuery($insert);

so my new code would be like this

$insert = "INSERT INTO friend_reg_user (username, fname, lname,  country, zip, city, gender, dob, disp_name, submit_date, uniqid, status,usstate,othstate,IP_ADD) VALUES ('$username','$fname', '$lname',  '$country', '$zip', '$city', '$gender', '$dob', '$fname', now(), '$uniqid', '$active','$usstate','$othstate','$LOCALIP')";
executeQuery($insert);


$insert = "INSERT INTO friend_reg_login (email, password) VALUES ('$email',  '$password_temp')";
executeQuery($insert);

[SFDonovan]

$db->sql_nextid()

Gets last inserted id (value of column with auto_increment/sequence) after insert statement

The problem is I don't see in this statement where you are inserting an autoincrement value.

$insert = "INSERT INTO friend_reg_user (username, fname, lname,  country, zip, city, gender, dob, disp_name, submit_date, uniqid, status,usstate,othstate,IP_ADD) VALUES ('$username','$fname', '$lname',  '$country', '$zip', '$city', '$gender', '$dob', '$fname', now(), '$uniqid', '$active','$usstate','$othstate','$LOCALIP')";
executeQuery($insert); 

It usually has a value of NULL.

[jasondavis]

thanks got it