Re: HELP PLEASE!! Get query error when inserting into MySql
| From: | DL Neil | Date: | Sun, 28 Oct 2001 14:42:36 +0000 |
| Subject: | Re: HELP PLEASE!! Get query error when inserting into MySql | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13781@lists.php.net to get a copy of this message | ||
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" <starbuxman@home.com>
To: "DL Neil" <PHPml@DandE.HomeChoice.co.uk>
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 ) " ;
>
>