Re: Re: Error Querying Database

"Steve Staples" <sstaples@mnsi.net> wrote in message news:1292447844.5460.16.camel@webdev01... > On Wed, 2010-12-15 at 15:41 -0500, Gary 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 > > > not sure if this is the issue or not, but you have reserved words in > your field names... try escaping them all in backticks... and the way i > do things with variables inside "", i put them in {}... here is what i > mean: > > 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}')"); > > Steve > > Steve Thanks again, that was the issue...let me throw that into my vault of knowledge about mysql (seems there is plenty of open space in there anyway) 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