TalkPHP - View Single Post

Wildhoney · 02-21-2008, 02:03 PM

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:

sql Code:

SELECT count FROM DESC

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

sql Code:

SELECT `count` FROM `desc`

02-21-2008, 02:03 PM	#2 (permalink)
Wildhoney La Vida es Sueño Join Date: Sep 2007 Location: Oldham Posts: 2,280 Thanks: 90	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: sql Code: SELECT count FROM DESC Whereas the back-ticks tell MySQL that `count` and `desc` are user entities, and not MySQL commands: sql Code: SELECT `count` FROM `desc` __________________ The man who comes back through the Door in the Wall will never be quite the same as the man who went out.