""Gary"" <gpaul@xxxxxxxxxxxxxxxx> wrote in message news:81.D1.49824.33C090D4@xxxxxxxxxxxxxxx >I cant seem to get this to connect. This is to my local testing server, >which is on, so we need not worry that I have posted the UN/PW. > > This is a duplicate of a script I have used countless times and it worked. > The error message is 'Error querying database.' > > Some one point out the error of my ways? > > Gary > > > <form action="<?php echo $_SERVER["PHP_SELF"]; ?>" method="post"> > <tr> > <td> > <label>Name of Beer</label></td><td><input name="beername" type="text" /> > </td> > </tr> > <tr> > <td> > <label>Maker of Beer</label></td><td><input name="manu" type="text" /> > </td> > </tr> > <tr> > <td> > <label>Type of Beer</label></td> > <td><select name="type" size="1" id="type"> > <option>Imported</option> > <option>Domestic</option> > <option>Craft</option> > <option>Light</option> > </select> > <!--<select name="avail" size="1" id="avail"> > <option>Available</option> > <option>Sold</option> > </select>--> > </td> > </tr> > <tr> > <td><label>Sold in</label> > </td><td><input type="checkbox" name="singles" value="Yes" /> Singles<br > /> > <input type="checkbox" name="six" value="Yes" /> Six Packs <br /> > <input type="checkbox" name="can" value="Yes" /> Cans<br /> > <input type="checkbox" name="bottles" value="Yes" /> Bottles <br /> > <input type="checkbox" name="tap" value="Yes" /> Draft <br /> > <tr> > <td> > <label>Size</label></td><td><input name="size" type="text" /> > </td></tr> > <tr><td> > <label>Description</label></td><td><textarea name="desc" cols="40" > rows="5"></textarea> > </td></tr> > <tr><td> > <input name="submit" type="submit" value="Submit" /></td></tr> > </form> > </table> > </div> > <div id="list"> > <?php > $beername = $_POST['beername']; > $manu = $_POST['manu']; > $type = $_POST['type']; > $singles = $_POST['singles']; > $six = $_POST['six']; > $can = $_POST['can']; > $bottles = $_POST['bottles']; > $tap = $_POST['tap']; > $size = $_POST['size']; > $desc = $_POST['desc']; > $ip= $_SERVER['REMOTE_ADDR']; > > $dbc = mysqli_connect('localhost','root','','rr')or die('Error connecting > with MySQL Database'); > > $query = "INSERT INTO beer (beername, manu, type, singles, six, can, > bottles, tap, size, desc, ip )"." VALUES ('$beername', '$manu', '$type', > '$singles', '$six', '$can', '$bottles', '$tap', '$size', '$desc', > '$ip' )"; > > $result = mysqli_query($dbc, $query) > or die('Error querying database.'); > > > mysqli_close($dbc); > I have tried something completely different, changed to mysql instead of mysqli and I put it up on my remote server/database, and it is still not behaving... mysql_connect('server','un','pw') or die(mysql_error()); mysql_select_db("db") or die(mysql_error()); mysql_query("INSERT INTO beer (beername, manu, type, singles, six, can, bottles, tap, size, desc, ip)"."VALUES "."('$beername', '$manu', '$type', '$singles', '$six', '$can', '$bottles', '$tap', '$size', '$desc', '$ip' )") or die(mysql_error()); echo "Data Inserted!"; I am now getting this error message, but it does not make sense You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc, ip)VALUES ('', '', 'Imported', '', '', '', '', '', '', '', '68.80.24.11' at line 1 Does this mean I am getting closer to getting some actual work done today? Thanks again gary __________ Information from ESET Smart Security, version of virus signature database 5706 (20101215) __________ The message was checked by ESET Smart Security. http://www.eset.com -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
