Hi!
I'm trying to write a php script to upload data into my database.
this works unless the data has double quotes in it- it then uploads with double double quotes (ie, <she said "hi"> will update as <she said ""hi"">
how do i get rid of these double quotes??
my code:
$abc = trim(mysql_real_escape_string(str_replace('\r\n','',$abc)));
$sqlf="UPDATE table1 SET abc ='$abc' WHERE key = '$key'";
Thank you!
Mysql update when data has quotes- problem!
Moderator: General Moderators