On Saturday 16 March 2002 13:08, Philip J. Newman wrote:
> A few of us folk at PhilipNZ.com would like to know about using " and ' or
> ` in My Sql when calling information from the database.
> we have always used
> $sql = "SELECT * FROM `hyperlinks` ORDER BY `clicks` DESC LIMIT 0, 10";
> but where told that the ` was not required
> $sql = "SELECT * FROM hyperlinks ORDER BY clicks DESC LIMIT 0, 10";
> Any Comments on this?

Yes, this should be posted to php-db.

For simple cases ` ` are not needed. It is only used if your column names 
contain weird characters, spaces for instance, then:

SELECT `First Name` FROM Address;

Jason Wong -> Gremlins Associates -> www.gremlins.com.hk

        A domineering man married a mere wisp of a girl.  He came back from
his honeymoon a chastened man.  He'd become aware of the will of the wisp.

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to