TalkPHP - View Single Post

Village Idiot · 04-21-2008, 08:46 PM

Ticks mark a user defined entity, I would use them. It prevents errors like this

Code:

SELECT * FROM from WHERE join = '1';

That will generate a syntax error since from and join are both commands. This, however, will run without error

Code:

SELECT * FROM `from` WHERE `join` = '1';

It also makes the code easier to read.

04-21-2008, 08:46 PM	#5 (permalink)
Village Idiot Wizard Join Date: Sep 2007 Posts: 1,296 Thanks: 17	Ticks mark a user defined entity, I would use them. It prevents errors like this Code: SELECT * FROM from WHERE join = '1'; That will generate a syntax error since from and join are both commands. This, however, will run without error Code: SELECT * FROM `from` WHERE `join` = '1'; It also makes the code easier to read. __________________