Re: [PHP] From: Newman, using and ' or ` in My Sql

2002-03-16 Thread mnc
On Sat, 16 Mar 2002, 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

[PHP] PHPMyAdmin: [PHP] From: Newman, using and ' or ` in My Sql

2002-03-16 Thread jtjohnston
The standard quote (') should be used to delimit string literals in MYSQL statements. Use it to surround strings you're inserting into or comparing against VARCHARs, CHARs, TEXTs, etc. $sql = UPDATE mytable SET name='Best Table Of All' WHERE id=3; That is ok if you call MySQL in your .php.

[PHP] From: Newman, using and ' or ` in My Sql

2002-03-15 Thread Philip J. Newman
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

Re: [PHP] From: Newman, using and ' or ` in My Sql

2002-03-15 Thread Jason Wong
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

Re: [PHP] From: Newman, using and ' or ` in My Sql

2002-03-15 Thread David Robley
In article [EMAIL PROTECTED], [EMAIL PROTECTED] says... 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