In article <[EMAIL PROTECTED]>, [EMAIL PROTECTED]
> 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;
And of course single quotes (') should be used to delimit text data being
inserted into CHAR type fields. But you knew that, of course.
Quod subigo farinam
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php