On Wed, 2010-12-15 at 15:41 -0500, Gary wrote: > ""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 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 -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
