Re: Re: Error Querying Database

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Wed, Dec 15, 2010 at 3:41 PM, Gary <gpaul@xxxxxxxxxxxxxxxx> 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
>
>
>
> __________ 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

-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php




[Index of Archives]     [PHP Home]     [Apache Users]     [PHP on Windows]     [Kernel Newbies]     [PHP Install]     [PHP Classes]     [Pear]     [Postgresql]     [Postgresql PHP]     [PHP on Windows]     [PHP Database Programming]     [PHP SOAP]

  Powered by Linux