Re: Solution

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