working with file

[hisham]

I have the folloing html file:

-------------------------
1:1 first record<br>
<br>
1:2 another one<br>
<br>
1:3 this one<br>
<br>
1:4 last record<br>
<br>

-------------------------

I need to insert the data of this file in a mysql DB table as:

insert into my_table ( foo, bar, mytext ) values (1,1,first record );
insert into my_table ( foo, bar, mytext ) values (1,2,another one );
insert into my_table ( foo, bar, mytext ) values (1,3,this one );
insert into my_table ( foo, bar, mytext ) values (1,4,last record );

Thanks in advance .

 

[sleipnir214]

[ul][li]

http://www.php.net/manual/en/function.fgets.php

(pay attention to the example code)[/li][li]

http://www.php.net/manual/en/function.explode.php

(you'll need to invoke this one twice per line)[/li][li]

http://us2.php.net/manual/en/function.mysql-fetch-assoc.php

(pay attention to the example code)[/li][/ul]


Want the best answers? Ask the best questions! TANSTAAFL!