Posted by John Holmes on 10/06/46 11:08

Shaun wrote:
> I have a problem with a query, I get the following error message:
>
> You have an error in your SQL syntax. Check the manual that corresponds to
> your MySQL server version for the right syntax to use near '' at line 23
>
> If I echo the query to the screen and run the query to the database via SSH
> it executes correctly.
>
> Does anyone have any ideas on what else I can check for here?

Check for the actual query you're using. If Query X gives the above
error when run in PHP, then copy and pasting it into the command line
will give the same error. Maybe you're not echoing/running the right
query? Errors like that are normally caused by a variable being empty.

--

---John Holmes...

Amazon Wishlist: www.amazon.com/o/registry/3BEXC84AB3A5E/

php|architect: The Magazine for PHP Professionals – www.phparch.com

• Prev in thread: Re: [PHP] Help with a query please - unable to error check!
• Next in forum: Re: paring large files - PHP or Perl
• Prev in forum: Re: [PHP] Help with a query please - unable to error check!
• Thread view: Help with a query please - unable to error check!

[Reply to this message]