I'm trying to insert data into two separate tables using 1 INSERT. The code
below represents a first crack at it, but I can't seem to figure out how to
get this to work properly.
Thanks.
Steve
<?
$db_name="testDB";
$table_name1 = "my_contacts";
$table_name2= "company";
$connection = @mysql_connect ("XXXX","XXXX","XXXXor die ("Couldn't
connect.");
$db = @mysql_select_db($db_name, $connection) or die ("Couldn't select
database.");
$sql_1 = "INSERT INTO $table_name1
(id,fname,lname,address1,address2,address3,postcode,country,prim_tel,sec_tel
,email,birthday)
VALUES
(\"\",
\"$fname\",\"$lname\",\"$address1\",\"$address2\",\"$address3\",\"$postcode\
",
\"$country\",\"$prim_tel\",\"$sec_tel\",\"$email\",\"$birthday\")
";
$sql_2 = "INSERT INTO $table_name2 WHERE my_contacts.company=$companyid
(companyname,website)
VALUES
(\"\",
\"$companyname\",\"$website\")
";
$result = @mysql_query ($sql_1,$sql_2,$connection) or die ("Couldn't
execute query.");
?>
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
