html-->mysql

[maryer]

dear all
i have html file, and input parameters are:

1) file.html

<h3>Events</h3>

(most recent first)

<ul>

<li>2003-02-12 10:27:57 : down
<li>2003-02-12 08:24:31 : back_up
<li>2003-02-12 08:13:55 : down
<li>2003-02-12 07:08:38 : back_up
<li>2003-02-12 01:22:40 : down
...........................................
etc etc etc etc

i need to get data about down and back_up and put it to the mysql table. If there is not back_up information, then data of down (in above case the last down doesn't have back_up so this down will not be transferred in table) we don't need to put on the table.

2) output parameters (mysql table where i have to put data of file.html):

Site | down | up
site1 | 2003-02-12 08:13:55 | 2003-02-12 08:24:31
site1 | 2003-02-12 01:22:40 | 2003-02-12 07:08:38
........................................................
etc etc etc

Should i use regular expression in loop?

Hope explanation is clear
Thank you in advance