Re: Help with a query please - unable to error check!

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