2 Tables- 1 Insert Problem
| From: | Steve Fitzgerald | Date: | Sun, 29 Jul 2001 04:05:01 +0000 |
| Subject: | 2 Tables- 1 Insert Problem | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-10868@lists.php.net to get a copy of this message | ||
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.");
?>