I see people putting "`" around input for the SQL, why?

Oh I get you now. Blond moment!

Basically the back-ticks should only be around the table names for the very reason that it distinguishes between a user string and a reserved word in MySQL:


Whereas the back-ticks tell MySQL that count and desc are user entities, and not MySQL commands:

__________________
The man who comes back through the Door in the Wall will never be quite the same as the man who went out.

-It defines commands from user entities as wild pointed out
-It looks cleaner in my opinion

I personally find it good coding to use the brackets so that if you accidentally name a table or field a command name, you wont have to worry about an error.

__________________
There are two ways to write bug-free code, only the third one works.

No one said this directly but hinted at it ... I believe the back ticks are MySQL specific.

__________________
Eric
Blog • phpBB