HELP PLEASE!! Get query error when inserting into MySql
| From: | robby at thedatasource dot net | Date: | Sat, 27 Oct 2001 12:20:35 +0000 |
| Subject: | HELP PLEASE!! Get query error when inserting into MySql | ||
| Groups: | php.general | ||
| Request: | Send a blank email to php-general+get-72558@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/