CodingForums.com - View Single Post

Old Pedant · 10-16-2012, 01:10 AM

But since literal strings in SQL should be enclosed in '...' and not in "..." and since PHP allows embedding variables in "..." strings, the easy way to do that is this:

Code:

$tablename = $GLOBALS['fc_config']['db']['pref'] . "connections";

$query = "DELETE FROM $tablename WHERE id = '$rid' ";

Yes, I know MySQL allows "..." around literal strings. But that's *NOT* ANSI SQL and so if you want to write mostly portable SQL code you shouldn't do it.

(In ANSI SQL, you use "..." around table and field names to allow non-standard names, the same way MySQL [uniquely among databases] uses `...` backticks.)

10-16-2012, 01:10 AM	PM User \| #12
Old Pedant Supreme Master coder! Join Date: Feb 2009 Posts: 23,248 Thanks: 59 Thanked 3,999 Times in 3,968 Posts	But since literal strings in SQL should be enclosed in '...' and not in "..." and since PHP allows embedding variables in "..." strings, the easy way to do that is this: Code: $tablename = $GLOBALS['fc_config']['db']['pref'] . "connections"; $query = "DELETE FROM $tablename WHERE id = '$rid' "; Yes, I know MySQL allows "..." around literal strings. But that's NOT ANSI SQL and so if you want to write mostly portable SQL code you shouldn't do it. (In ANSI SQL, you use "..." around table and field names to allow non-standard names, the same way MySQL [uniquely among databases] uses `...` backticks.) __________________ An optimist sees the glass as half full. A pessimist sees the glass as half empty. A realist drinks it no matter how much there is.