Hi,

I have a table with a text field, when using

UPDATE database_name SET col_name=whatever;

how do I load a local text file in place of whatever?



Thnx...Steve

sounds like you need to read the csv file contents via a web page then insert into mysql.

In the past I have used: @fgetcsv($fp, 1024, ",");

that reads each line from the csv file into an array which acn be iterated through. MySQL insert queries then can be built and executed.

alternatively a quick google search find this:
http://www.codenewbie.com/forum/t2047.html

Let me know if I've missed the point or if you'd like a further code sample.

Matthew McNicol