|
|
Posted by Mr. Newt on 04/07/07 00:45
Hi y'all,
I wrote the following:
<?php
include ("connect.php");
$sql = "INSERT INTO advertiser_info_tbl (adv_name) values ('$adv_name')";
$sql = "INSERT INTO address_info_tbl (address, apt, city, state, zip) values
('$address',
'$apt', '$city', '$state', '$zip')";
if (mysql_query($sql, $conn)){
echo "record added!";
} else {
echo "something went wrong";
}
?>
This seems to work with no error messages. Unfortunately, it doesn't put
any data into the first table (advertiser_info_tbl). It only puts data in
the second table. Is this possible? I've seen that you can retrieve data
from multiple tables at the same time, so I figure there must be a way.
Any help would be appreciated.
Robert
Navigation:
[Reply to this message]
|