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) VALUES ('$country', '$city') > > Any thoughts on the issue? Thanks.Single quotes are supported in any db (mysql, postgres, sqlite etc etc) - so use them. No idea if double quotes are widely supported. 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). -- Postgresql & php tutorials http://www.designmagick.com/
Thanks. I'll just keep using single quotes then, as I've always done. Dotan Cohen http://lyricslist.com/lyrics/artist_albums/338/meat_loaf.html http://what-is-what.com/what_is/404.html -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
