Re: Solution
| From: | Karl DeSaulniers | Date: | Mon, 12 Apr 2010 22:31:54 +0000 |
| Subject: | Re: Solution | ||
| References: | 1 2 3 4 5 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-304016@lists.php.net to get a copy of this message | ||
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