[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\"


More information about the thelist mailing list