[bud144]

Hi,
This is the error message i receive:
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 1

A question before I post any of my code:
This code has been working fine until I moved from one server to another, does anyone know any reason why there should be an error like this after transferring to a different server?
any help appreciated
Bud

[phplabs]

could be a different magic quotes setting. check if your quotes (and other special symbols) are escaped in the new server.

[bud144]

Magic quotes is set to on
Is there another way to test if magic quotes is causing the problem?

[phplabs]

Originally Posted by bud144

Magic quotes is set to on
Is there another way to test if magic quotes is causing the problem?

print the SQL query to screen before executing it and see if it contains any unnecessary quotes. if not quotes, perhaps you'll notice some other errors - such as missing variables, etc. perhaps the global variables ($_GET, $_POST, etc) are working in a different way on a new server and that's causing problems.

[exoticious]

Magic quotes is set to on
Is there another way to test if magic quotes is causing the problem?

[kfurlong]

Originally Posted by exoticious

Magic quotes is set to on
Is there another way to test if magic quotes is causing the problem?

Turn it off and then check to see if it works. If it does then it was causing the problem. If not then you can set it back

PHP: Magic Quotes - Manual

[Nico]

Magic Quotes is a deprecated feature. If you still have it enabled, you should probably upgrade PHP.

Instead, you should use mysql_real_escape_string() for database input. That's a lot more secure, and should avoid errors like this.