using mysql_escape_string with implode() !!

From: Date: Fri, 25 May 2007 15:32:50 +0000
Subject: using mysql_escape_string with implode() !!
Groups: php.general 
Request: Send a blank email to php-general+get-255649@lists.php.net to get a copy of this message
Ave, I¹m inserting values out of an array into mySQL. There¹s other values besides the array values that are being inserted as well. This is my simple INSERT code: $sql = "INSERT INTO db (Date,Time,Phone,Account,AccountType,RateClass,VoltLevel,IsoZone,TaxDist,Loa dProfile,ServiceName,ServiceAddress,ServiceCity,ServiceState,ServiceZip,Dema nd,Kwh,Cost) VALUES ('$dt','$tm','$thephone','".implode("','", array_values($var))."')"; $var can contain values that have special characters that I need to escape. I¹d like to use mysql_escape_string() but I¹m not sure how to integrate mysql_escape_string here with the INSERT statement. I tried it, but it¹s not working. Any clues? Thanks. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Rahul Sitaram Johari CEO, Twenty Four Seventy Nine Inc. W: http://www.rahulsjohari.com E: sleepwalker@rahulsjohari.com ³I morti non sono piu soli ... The dead are no longer lonely²

« previous php.general (#255649) next »