Just a heads-up.
I was having problems doing a MySql infile insert with a flat file uploaded
from an html form. I discovered that ascii character 10 (new line \n,\r) is
being changed to ascii character 13 (charriage return) when it is uploaded.
MySql didn't recognize the ascii-13 character as a new line and as a result
tried to write the remaining data into the last cell of my table.
Also, a quick question. Since PHP can only handle single MySql queries is it
better to write data for large insert operations to a temp file and then do
an infile insert?
easy,
loop
_________________________________________________________________
Protect your PC - get McAfee.com VirusScan Online
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
