Help with quotes
Posted: Sun Mar 22, 2009 2:05 pm
I have an issue with single quotes in my update queries maybe someone can shine some light on this for me.
While this does not:
so obviously ` != ' but could someone explain this to me.
Thanks John.
Code: Select all
$query = "UPDATE `properties`
SET
`ZID` = '$zid',
`name` = '$name'
WHERE `PID` = $pid
LIMIT 1;";
Code: Select all
$query = "UPDATE 'properties'
SET
'ZID' = '$zid',
'name' = '$name'
WHERE 'PID' = $pid
LIMIT 1;";
Thanks John.