Error in MySQL/PHP real_escape_string UPDATE function

   $query = sprintf("UPDATE populationgender SET male='%s', female = '%s' WHERE popgenderid='4'",
             mysql_real_escape_string($male),
             mysql_real_escape_string($female));

Is this a 开发者_Python百科valid sprintf code? because when i use this it does nothing hehe it is connected via googlemaps btw :) pls help thanks :)

You have used escape in javascript as well as php. Try using escape in javascript and unescape in php.

$myvar = urldecode($_GET["male"]);

this will work