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:
But now, when I copied the app to the server online, an external host, it gives me errors. Now I have to use:
Is there a way to tell MySQL to act normal, like my localhost does; and to stop complaining about the absence of quotes?

Dear Hylmar,
I never seen to use quote (' ') in table or field name. I have seen using `` .
So your statement should be:
SELECT `name` FROM `users` WHERE name='test';

if you write this statement: SELECT 'name' FROM users WHERE name='test'; you should get name itself as value not any value in the name column.

So far I know, its a better practice to use quotes for value and `` for fields, tables

Best Regard:
Md. Zakir Hossain (Raju)

www.rajuru.xenexbd.com - my blog with PHP scripts, PHP Book Review and many more

simply u can wtite

select name from users whre name ='test';

no error u will get

Success is Never Ending,,Filure is Never Fimal

using quotes is better as all versions of mysql understand that
gives out lesser problems
must be made a habit

---
Paagle
TEAM LEADER-Team Xuberance(http://www.xuberance.com)