Re: [PHP-DB] CSV/TXT file imported via PHP into MySQL

2002-06-10 Thread Srinivasan Ramakrishnan
Have you tried to get the fields programmatically via fgetcsv() You could open the file, and fgetcsv() each record one by one and insert the normal way. This way it'll be a lot more portable across databases. -Srini -- http://symonds.net/~sriniram - Original Message - From: "Keiran Wyny

RE: [PHP-DB] CSV/TXT file imported via PHP into MySQL

2002-06-10 Thread Beau Lebens
Keiran, in your second page, you refer to $textfile as the thing that you want to load into the database; this file doesn't exist on the server, so it is inserting nothing I would imagine. You need to use something like $_FILES['tmp_name'] to refer to the actual file, once it has been successfull