data transfer - pls help

Dear all,
In mysql database there is table downup
************************
site enum('site1', 'site2'),
down datetime,
up datetime
************************
and there is file with such statistics about site1, site2 down and up period
************************
2003-01-28 15:42:08 (back up)
2003-01-27 14:05:45 (down)
2003-01-25 15:54:17
2003-01-25 15:11:19
2003-01-23 09:38:19
2003-01-23 09:06:55
2003-01-10 13:42:38
2003-01-10 12:45:40
2003-01-07 01:56:44
2003-01-07 01:34:47
************************
how to transfer these datas to the mysql table. it is need check if there is not back up the data will not be transffered and always check the highest datetime / event has to be writen on the top/last.
should i use regular expression (preg_match)
I would be very thankful if you help me as soon as possible.
Best regards
Maryer

You can use the mysql command LOAD DATA INFILE, below is an example

$sql = "LOAD DATA INFILE '/my/dir/file.txt' INTO TABLE downup LINES TERMINATED BY '\n' (site, down, up)";

This might help you.
You can read more about this command at MySQL website, here is the link:

http://www.mysql.com/doc/en/LOAD_DATA.html

thank you very much for reply, but this doesn't help much because it gave NULL in mysql table. though .txt file is not empty

maybe i have to use file() functions to get information from html file and then regular expression to get right data and insert it to the mysql table?

thank you