Re: Solution

My mistake. You are correct. Karl On Apr 13, 2010, at 2:16 PM, Jim Lucas wrote: Karl DeSaulniers wrote:

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')";

Their are a few syntax variations available, but the one that they used is not a valid format. The following are the insert statements written in a valid format. $query_name = "INSERT INTO name (

     fname,    lname

) VALUES ( '$fname', '$lname' )"; $query_address = "INSERT INTO address (

     street,    town,    state,    zip

) VALUES { '$street', '$town', '$state', '$zip' )"; Try this, it should work.

$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

-- Jim Lucas "Some men are born to greatness, some achieve greatness, and some have greatness thrust upon them." Twelfth Night, Act II, Scene V by William Shakespeare -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php Karl DeSaulniers Design Drumm http://designdrumm.com