""Gary"" <[email protected]> wrote in message
news:[email protected]...
>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
