note 29820 added to function.mysql-query

this is rather obvious, but it gave me a lot of pain, so I'll post it here. mysql does not understand single quotes (') or backslashes (\) in queries, so if you need to add something containing these signs to a mysql database, use urlencode : $foo = "jimmy's chicken shack"; $foo = urlencode($foo); -- http://www.php.net/manual/en/function.mysql-query.php http://master.php.net/manage/user-notes.php?action=edit+29820 http://master.php.net/manage/user-notes.php?action=delete+29820 http://master.php.net/manage/user-notes.php?action=reject+29820