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

[Back to original message]