RE: [PHP-DB] Parse error on array and SQL query
| From: | Hutchins, Richard | Date: | Thu, 20 Nov 2003 18:14:42 +0000 |
| Subject: | RE: [PHP-DB] Parse error on array and SQL query | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-31670@lists.php.net to get a copy of this message | ||
If you're not getting the parse error anymore, I'd suggest you echo $query
to the browser and check to see that the SQL statement is what you expect it
to be. Can't count the number of times doing that has pointed out some stray
apostrophe or comma or something that killed the query.
> -----Original Message-----
> From: John W. Holmes [mailto:holmes072000@charter.net]
> Sent: Thursday, November 20, 2003 1:09 PM
> To: Dillon, John
> Cc: php-db@lists.php.net
> Subject: Re: [PHP-DB] Parse error on array and SQL query
>
>
> Dillon, John wrote:
>
> > Tried that, doesn't work with:
> >
> > $query="INSERT INTO ReplyTbl VALUES ('" . $monster1 . "',
> > '" .
> > $monster2 .
> > "', '" . $monster3 . "', NULL, NULL)";
> >
> > Don't suppose they use 'monster' as a reserved word...
>
> How does it "not work" again??
>
> --
> ---John Holmes...
>
> Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/
>
> php|architect: The Magazine for PHP Professionals www.phparch.com
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>