[thelist] Odd Behavior last night with MySQL Server
Rob Smith
rob.smith at THERMON.com
Fri Aug 6 09:41:22 CDT 2004
>Is there any chance that the insert is overflowing the fifth column?
The data types for l1-5 are varchar(50). I haven't found a "item" longer
than that.
If I escape the single apostrophes, won't it escape the double quotes as
well? For example:
11,"Home","Books","Sweets","Valentine's Candy",""
$line = explode (",",$row[$i]);
Insert INTO ofnav '" . addslashes($line[0]) . "'
Might result in:
\"Valentine\'s Candy\"
Rob
More information about the thelist
mailing list