Seriously You should read your answers before you post, the SA link did not provide the answer. Had you read the page you sent, you would notice it does not apply to mulitple tables...
Gary "Colin Streicher" <co...@obviouslymalicious.com> wrote in message news:201004112310.16594.co...@obviouslymalicious.com... > 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" > > __________ Information from ESET Smart Security, version of virus > signature database 5021 (20100412) __________ > > The message was checked by ESET Smart Security. > > http://www.eset.com > > > __________ Information from ESET Smart Security, version of virus signature database 5021 (20100412) __________ 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=arch...@jab.org
