INSERT & mysql_insert_id question

Anon

Ok, so here's the deal. My PHP code is correctly inserting the correct data into the correct table, but still giving me an error message. To top it off, I'm not sure I've declared the mysql_inser_id function correctly:

else    
		{

if (!($newresult = mysql_db_query($DB, "INSERT INTO address_record (address1,address2,city,day_phone)
VALUES ('".addslashes($form_address_line1)."','".addslashes($form_address_line2)."','".addslashes($form_city)."','".addslashes($form_phone)."')"))); {

                           DisplayErrMsg(sprintf("internal errors %d:%s\n", 
                           mysql_errno(), mysql_error()));
                        exit();
			}

                $addressid = mysql_insert_id(); 
                $balance = 0.00;	
                if (!($newresult2 = mysql_db_query($DB, "INSERT INTO user_profile (user_name,login_name,password,email_id,account_balance,address_record_id) 
                	      VALUES ('".addslashes($form_name)."','".addslashes($form_user_id)."','".addslashes($form_password)."','".addslashes($form_email_id)."','".addslashes($balance)."','".addslashes($addressid)."')"))); {

                           DisplayErrMsg(sprintf("internal error %d:%s\n", 
                           mysql_errno(), mysql_error()));
                        exit();
			}

Any ideas? Thanks for any input!

Anon

Not sure about the error message part, but you need to use $addressid = mysql_insert_id($newresult);

for the mysql_insert_id.

Also you may want to addslashes before the INSERT statement, but I am not sure about that. Like:
$form_address1_line1 = addslashes($form_address1_line1);
$form_address2_line2 = addslashes($form_address2_line2);
$form_city = addslashes($form_city);
$form_phone = addslashes($form_phone);

if (!($newresult = mysql_db_query($DB, "INSERT INTO address_record (address1,address2,city,day_phone)
VALUES ('$form_address_line1','$form_address_line2','$form_city','$form_phone')"))); {

Hope that helps!

Anon

Hey, great, I'll give it a shot! Thanks for the input...

Chris

Anon

SUM:

Code was fine. Problem was I was using addslashes before a variable that was being set on the page and was an INTERGER in the database. Once I declared the variable as simply '$myvariable', everything worked out ok.

Thanks to all for help!