Re: [PHP] Enclosing fields in MySQL queries with `" or '

2007-03-13 Thread Dotan Cohen
On 13/03/07, Richard Lynch <[EMAIL PROTECTED]> wrote: On Wed, March 7, 2007 1:22 pm, Dotan Cohen wrote: >> A backtick (`) on the other hand is a mysql-ism. It allows you to >> use >> keywords as field names (eg `index`) amongst other things (including >> quoting strings). I *think* that this is

Re: [PHP] Enclosing fields in MySQL queries with `" or '

2007-03-12 Thread Richard Lynch
On Wed, March 7, 2007 1:22 pm, Dotan Cohen wrote: >> A backtick (`) on the other hand is a mysql-ism. It allows you to >> use >> keywords as field names (eg `index`) amongst other things (including >> quoting strings). I *think* that this is actually SQL-92 specification, but don't quote me on tha

Re: [PHP] Enclosing fields in MySQL queries with `" or '

2007-03-07 Thread Dotan Cohen
On 05/03/07, Chris <[EMAIL PROTECTED]> wrote: Dotan Cohen wrote: > Are there any advantages/disadvantages to using and of the ` " or ' > punctuation symbols in MySQL queries? I usually only put them around > variables (after being sanitized, of course): > > INSERT INTO places (country, city) VALU

Re: [PHP] Enclosing fields in MySQL queries with `" or '

2007-03-04 Thread Chris
Dotan Cohen wrote: Are there any advantages/disadvantages to using and of the ` " or ' punctuation symbols in MySQL queries? I usually only put them around variables (after being sanitized, of course): INSERT INTO places (country, city) VALUES ('$country', '$city') Any thoughts on the issue? Th

[PHP] Enclosing fields in MySQL queries with `" or '

2007-03-04 Thread Dotan Cohen
Are there any advantages/disadvantages to using and of the ` " or ' punctuation symbols in MySQL queries? I usually only put them around variables (after being sanitized, of course): INSERT INTO places (country, city) VALUES ('$country', '$city') Any thoughts on the issue? Thanks. Dotan Cohen