Re: From: Newman, using " and ' or ` in My Sql

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. */