Joshua, Thanks for this. The original question wasn't mine, but I'm sure Robby will be interested to read it... =dn
----- Original Message ----- From: "Joshua Long" <[EMAIL PROTECTED]> To: "DL Neil" <[EMAIL PROTECTED]> Sent: 28 October 2001 07:10 Subject: Re: [PHP-DB] HELP PLEASE!! Get query error when inserting into MySql > Hmm, I'm not sure if this will help, but it can't hurt. > > > > $sql = "INSERT INTO vcstats VALUES('', $SCRIPT_NAME, $date, > $HTTP_USER_AGENT,$BName, $BVersion, $BPlatform, $REMOTE_ADDR, $host1)"; > > I suspect that this si your problem: you have commas where a string joiner > thingy should be, ie > > $sql = "INSERT INTO vcstats VALUES( " ; /* < --- prior to this, > you had a comma.*/ > $sql .= "$SCRIPT_NAME, $date, $HTTP_USER_AGENT,$BName, $BVersion, > $BPlatform, $REMOTE_ADDR, $host1 ) " ; > > -- PHP Database 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]