HELP PLEASE!! Get query error when inserting into MySql
| From: | Robby Whiteside | Date: | Sat, 27 Oct 2001 12:15:55 +0000 |
| Subject: | HELP PLEASE!! Get query error when inserting into MySql | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13767@lists.php.net to get a copy of this message | ||
Hi There,
I have a query whenever I try to insert something into a mysql table. This is
the code I am using:
<?
$host1 = gethostbyaddr("$REMOTE_ADDR");
$date = date("Y-m-d h:i:s");
$link = mysql_connect("$host", "$user", "$passwd");
mysql_select_db("$database", $link);
$sql = "INSERT INTO vcstats VALUES('', $SCRIPT_NAME, $date, $HTTP_USER_AGENT,
$BName, $BVersion, $BPlatform, $REMOTE_ADDR, $host1)";
$result = mysql_query($sql) or die("query error<Br>" . mysql_error());
mysql_close();
?>
Thanks,
Robby
---------------------------------------------
This message was sent using Endymion MailMan.
http://www.endymion.com/products/mailman/