Seriously... I found the answer in the first result. http://lmgtfy.com/?q=mysqli+multiple+insert+statements
Assuming mysqli, if you are using a different driver, then google that Colin On April 11, 2010 10:36:41 pm viraj wrote: > is it mysqli query or 'multi_query'? > > http://php.net/manual/en/mysqli.multi-query.php > > ~viraj > > On Sun, Apr 11, 2010 at 10:27 PM, Gary <gwp...@ptd.net> wrote: > > I am experimenting with multiple tables, it is only a test that is my > > local machine only. This is the current code, which does not work , I > > have tried to concatonate the insert statements. I have tried multiple > > $query variables, but it is just overwriting itself (only the last one > > gets inserted). I also tried writing the $query as an array, which got me > > an error message (saying it was expecting a string and I offered an > > array). > > > > Someone point me in the right direction? > > > > Gary > > > > <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" > > "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd";> > > <html xmlns="http://www.w3.org/1999/xhtml";> > > <head> > > <meta http-equiv="Content-Type" content="text/html; charset=utf-8" /> > > <title>Untitled Document</title> > > </head> > > > > <body> > > > > <form action="<?php echo $_SERVER['PHP_SELF'];?>" method="post"> > > > > <label>First Name </label> <input name="fname" type="text" /><br /><br /> > > <label>Last Name </label><input name="lname" type="text" /><br /><br /> > > <label>Street Address </label><input name="street" type="text" /><br > > /><br /> > > <label>Town </label><input name="town" type="text" /><br /><br /> > > <label>State </label><input name="state" type="text" /><br /><br /> > > <label>Zip Code</label><input name="zip" type="text" /><br /><br /> > > <label>Telephone</label><input name="phone" type="text" /><br /><br /> > > <label>Fax</label><input name="fax" type="text" /><br /><br /> > > <label>E-Mail</label><input name="email" type="text" /><br /><br /> > > <label>Comments</label><br /><textarea name="comments" cols="100" > > rows="15"></textarea><br /><br /> > > > > <input name="submit" type="submit" value="submit" /> > > </form> > > > > <?php > > > > $fname=($_POST['fname']); > > $lname=($_POST['lname']); > > $street=($_POST['street']); > > $town=($_POST['town']); > > $state=($_POST['state']); > > $zip=($_POST['zip']); > > $phone=($_POST['phone']); > > $fax=($_POST['fax']); > > $email=($_POST['email']); > > $comments=($_POST['comments']); > > $REMOTE_ADDR=$_SERVER['REMOTE_ADDR']; > > > > $dbc=mysqli_connect('localhost','root','','test'); > > $query="INSERT INTO address (street, town, state, > > zip)"."VALUES('$street','$town','$state','$zip')". > > "INSERT INTO comments(comments)"."VALUES('$comments')". > > "INSERT INTO > > contact(phone,fax,email)"."VALUES('$phone','$fax','$email')". "INSERT > > INTO name (fname, lname)"."VALUES('$fname','$lname')"; > > > > $result = mysqli_query($dbc, $query) > > or die('Error querying database.'); > > > > mysqli_close($dbc); > > > > ?> > > </body> > > </html> > > > > > > > > __________ Information from ESET Smart Security, version of virus > > signature database 5017 (20100411) __________ > > > > The message was checked by ESET Smart Security. > > > > http://www.eset.com > > > > > > > > > > > > -- > > MySQL General Mailing List > > For list archives: http://lists.mysql.com/mysql > > To unsubscribe: http://lists.mysql.com/mysql?unsub=kali...@gmail.com > -- It is easy to find fault, if one has that disposition. There was once a man who, not being able to find any other fault with his coal, complained that there were too many prehistoric toads in it. -- Mark Twain, "Pudd'nhead Wilson's Calendar" -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
