|
|
Posted by Robert on 10/13/32 11:44
This one really has me stumped.
I need to add or update a mysql table with a string that includes double
quotes. I use the addslashes() function to set the necessary escapes. This
works with INSERT. However, with UPDATE the string is truncated at the first
double-quote. (No problem with single-puote.)
This code works, no problem:
$line1=$_POST['item1'];
$line1=addslashes($line1);
mysql_query("INSERT INTO $tablename (info) VALUES('$line1') ") or
die(mysql_error());
With this code, the string is truncated when a double-quote is encountered.
$title1=$_POST['T1'];
$title1=addslashes($title1);
mysql_query("UPDATE $tablename SET info='$title1' WHERE id='1' ") or
die(mysql_error());
I would be very grateful for any explanation of this problem
Thanks, Robert
Navigation:
[Reply to this message]
|