[SOLVED] difference between quoted and not quoted sql column names?

[web_master]

hi,

 

can somebodz tell me what is the difference between quoted and not quoted sql column names?

 

 

$query = mysql_query("SELECT * FROM table WHERE row = '$row'");

 

OR

 

$query = mysql_query("SELECT * FROM `table` WHERE `row` = '$row'");

 

thankx

[trq]

They are not quotes, but backticks. Quotes will cause a syntax error.

 

Backticks are used to escape reserved words. For instance, DESC is a reserved word in sql. If you wanted to have a filed name called DESC, you'd need to surround it with backticks.

 

IMO, reserved words should be avoided (they are after, reserved for a reason). They do nothing but cause confusion. If you never use reserved words, you have no need at all for backticks.

[web_master]

They are not quotes, but backticks. Quotes will cause a syntax error.

 

Backticks are used to escape reserved words. For instance, DESC is a reserved word in sql. If you wanted to have a filed name called DESC, you'd need to surround it with backticks.

 

IMO, reserved words should be avoided (they are after, reserved for a reason). They do nothing but cause confusion. If you never use reserved words, you have no need at all for backticks.

 

I see, thnax for answer!

[ToonMariner]

I use backticks all teh time in my code just to differentiate between fields and values... I fin it helps but as thorpey says - it's not neccessary.