Quotes in the Query

[Saj]

I have recently found that different types of quotes work for me...

Basicly when should quotes be used, like ` or ', and how?

Thanks

[Jeewhizz]

backquotes should be used to quote a table, field or database name:

SELECT `table`.`field`,`table2`.`field`FROM `table`,`table2`

You use the normal single quotes when you are quoting a varialbe in PHP for example:

SELECT `table`.`field`,`table2`.`field`FROM `table`,`table2` WHERE `table`.`field` = '$variable'

Jee

[Spookster]

Originally posted by Jeewhizz
You use the normal single quotes when you are quoting a varialbe in PHP for example:


only if that variable is suppose to be a string otherwise you should not quote it.

[Jeewhizz]

Cheers bud ;)

[Saj]

Cool. Thanks for clearing that up for me :thumbsup: