Hey Gary, instead try something like this maybe?
$dbc=mysqli_connect('localhost','root','','test') or die('Error
connecting to MySQL server');
$query_name="INSERT INTO name(fname='$fname', lname='$lname')";
$query_address="INSERT INTO address (street='$street', town='$town',
state='$state', zip='$zip')";
$result1=mysqli_query($dbc, $query_name) or die('Error querying
database for name.');
$result2=mysqli_query($dbc, $query_address) or die('Error querying
database for address.');
echo "Success!<br />";
?>
HTH,
Karl
On Apr 12, 2010, at 5:16 PM, Peter Lind wrote:
$dbc=mysqli_connect('localhost','root','','test')or die('Error
connecting to
MySQL server');
$query="INSERT INTO name(fname, lname)"."VALUES('$fname','$lname')";
$result=mysqli_query($dbc, $query)
or die('Error querying database.');
mysqli_close($dbc);
?>
<?php
$dbc=mysqli_connect('localhost','root','','test')or die('Error
connecting to
MySQL server');
$query="INSERT INTO address (street, town, state,
zip)"."VALUES('$street','$town','$state','$zip')";
$result=mysqli_query($dbc, $query)
or die('Error querying database.');
mysqli_close($dbc);
?>
Karl DeSaulniers
Design Drumm
http://designdrumm.com
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
