mysql and loading (PHP)

[CaShY]

Hi i have come accross a little problem that i need some help with

basically i need to load a file into my mysql database and this all works fine using a cvs file and the LOAD feature

which goes like

LOAD DATA LOCAL INFILE $file INTO TABLE `results` FIELDS TERMINATED BY ',' ESCAPED BY '\\' LINES TERMINATED BY '\r\n'(
`userid` , `network` , `profit`
)

however theres a 4th collumn in my table that i want to put data into. I want to put in the date it was added in the 4th feild in my table however this need to be the time(); function in php. Is there anyway to combine the two so that it will also automatically put in the time of the insert.

Thanks

[wu_trax]

you could use fgetcsv, then foreach all the way through the result and create insert-statments.
that will probably be slower than what you do now, but it should work.
i didn't even now what you did there is possible, so thanks for the info, maybe there is another way.

[pablissimo]

If the column that you want to have the current time in is of type TIMESTAMP and you don't specify it as one of the fields getting data in your LOAD DATA INFILE then it should be set to the current date/time which sounds similar at least to what you want. If it's any other type then you might be stuck, as far as I was aware default values on columns cannot be evaluated at insertion-time so you can't directly use mySQL functions in them.

Alternatively, you could load all of that data into a temporary table and then propagate your original table iteratively (or if there's some mySQL function for it, I don't know) inserting the current time as part of the query to build the table.

[queball]

Or if you particularly need the result from PHP's time(), you could always insert just the data you have, then use an UPDATE to change all those records time field appropriately.