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
-- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php