[PHP] HELP PLEASE!! Get query error when inserting into MySql

2001-10-27 Thread robby 

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 errorBr . mysql_error());
mysql_close();

?

Thanks,
Robby

-
This message was sent using Endymion MailMan.
http://www.endymion.com/products/mailman/



-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Re: [PHP] HELP PLEASE!! Get query error when inserting into MySql

2001-10-27 Thread Valentin V. Petruchek 

What if you single quotes like this:
'$REMOTE_ADDR'
???
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Saturday, October 27, 2001 3:20 PM
Subject: [PHP] HELP PLEASE!! Get query error when inserting into MySql


 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 errorBr . mysql_error());
 mysql_close();

 ?

 Thanks,
 Robby

 -
 This message was sent using Endymion MailMan.
 http://www.endymion.com/products/mailman/



 --
 PHP General Mailing List (http://www.php.net/)
 To unsubscribe, e-mail: [EMAIL PROTECTED]
 For additional commands, e-mail: [EMAIL PROTECTED]
 To contact the list administrators, e-mail: [EMAIL PROTECTED]





-- 
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]