insert into 2 tables in one form

I would like make INSERT INTO to two different MySQL tables. For example,

1. insert customer details in tblcustomer
2. insert customer address in tbladdress

Can I make it in

$result = mysql_query(
  "INSERT INTO tblcustomer(
     txtaccount_name,txtfirst_name,txtlast_name,txtemail
     ,intoffice_no,intfax,intmobile,intother_no,dtebirth_date)
   VALUES('$acc_name','$fname','$lname','$email',
   '$office','$fax_no','$mobile_no','$others_no','$date')");

$result1 = mysql_query(
  "INSERT INTO tbladdress(
     txtmailing_add,txtothers_add,txtmailing_street,txtothers_street,
     txtmailing_city,txtothers_city,txtmailing_state,txtothers_state,
     txtmailing_postcode,txtothers_postcode,txtmailing_country,
     txtothers_country)    
  VALUES('$m_add','$o_add','$m_street','$o_street',
     '$m_city','$o_city','$m_state','$o_state',
     '$m_开发者_JAVA技巧postcode','$o_postcode','$m_country',
     '$o_country')");

---

Yes that would work, but you would have to execute two queries to the database, I suggest using PDO. It support transactions.

---

You can insert with these queries but you should make connection between customer table and customer address table if you already did not done.

They should be connected by a foreign key or something like that if the engine is not innodb.

You should escape user input using mysql_real_escape_string

or better to use PDO.