Problem with quotes

[Hylmar]

I'm working on a CMS and it's almost finished now, but I encountered a problem.

Althroughout the code I've used query's like:
SELECT name FROM users WHERE name='test';


But now, when I copied the app to the server online, an external host, it gives me errors. Now I have to use:
SELECT 'name' FROM users WHERE name='test';


Is there a way to tell MySQL to act normal, like my localhost (MySQL 5.0.15) does; and to stop complaining about the absence of quotes on the external host (MySQL 4.1.21)?

Any help appreciated.

[fenway]

Well, I assume you mean backticks, not quotes... and I don't know about any issues with MySQL 5 that have to do with this, unless they added some reserved keywords I don't know about.