Re: Re: Error Querying Database

On Wed, Dec 15, 2010 at 3:41 PM, Gary <gpaul@paulgdesigns.com> wrote: > > ""Gary"" <gpaul@paulgdesigns.com> wrote in message > news:81.D1.49824.33C090D4@pb1.pair.com... >>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 > > DESC is a reserved word in mysql ( http://dev.mysql.com/doc/refman/5.1/en/reserved-words.html ) Either change the field name or enclose the statement in backticks to prevent this error. Changing the field name is my recommended action -- Bastien Cat, the other other white meat