OK, here's the scoop. I want to insert a large amount of freeform text into a mysql table. The php statement that builds the query is like so:
$sql = "insert into leads values(\"\", \"$date_valid\", \"$state_valid\",\"$title\", \"$v_lead\")";
The "lead" column (v_lead) has a type of "longtext".
Said text is to be cut and pasted from existing documents. It *will* have lots of quotes (") in it that will foul things up. How to get around this?
$sql = "insert into leads values(\"\", \"$date_valid\", \"$state_valid\",\"$title\", \"$v_lead\")";
The "lead" column (v_lead) has a type of "longtext".
Said text is to be cut and pasted from existing documents. It *will* have lots of quotes (") in it that will foul things up. How to get around this?