For anybody interested in this topic. I solved the prob with followin php script:
$datei = "malaria_yellowfeewer.txt"; $line = file($datei); for($x=0;$x<count($line);$x++){ for ($c=0;$c<count($country);$c++){ if (substr($country[$c],0,4) == substr($line[$x],0,4)){ echo $country[$c].$br; /* yellow fewer if (substr($line[$x+3],0,4)== 'Yell'){ $yellow_f = str_replace("Yellow fever: ", "",$line[$x+3]); #insert into table $stmt= " UPDATE $DB2.countries SET yellow_fever = '$yellow_f' WHERE country = '$country[$c]' "; $result = execute_stmt($stmt, $link); ################### echo $yellow_f; echo "<br>"; } */ // malaria if (substr($line[$x+3],0,4)== 'Mala'){ $malaria = str_replace("Malaria: ", "",$line[$x+3]); #insert into table $stmt= " UPDATE $DB2.countries SET malaria = '$malaria' WHERE country = '$country[$c]' "; $result = execute_stmt($stmt, $link); ################### echo $malaria; echo "<br>"; } if (substr($line[$x+2],0,4)== 'Mala'){ $malaria = str_replace("Malaria: ", "",$line[$x+2]); #insert into table $stmt= " UPDATE $DB2.countries SET malaria = '$malaria' WHERE country = '$country[$c]' "; $result = execute_stmt($stmt, $link); ################### echo $malaria; echo "<br>"; } if (substr($line[$x+4],0,4)== 'Mala'){ $malaria = str_replace("Malaria: ", "",$line[$x+4]); #insert into table $stmt= " UPDATE $DB2.countries SET malaria = '$malaria' WHERE country = '$country[$c]' "; $result = execute_stmt($stmt, $link); ################### echo $malaria; echo "<br>"; } } } } Hope I could help somebody else Andy "Andy" <[EMAIL PROTECTED]> schrieb im Newsbeitrag [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > Hi there, > > I want to include some data into my website which covers malaria and yellow > feewer related to each country. On the WHO website are all the infos I need. > Their webmaster told me that unfortunatelly there is no db behind that and > everything gos with html files. But I am free to extract that data. > > Well, I did create a txt file which looks more or less like that: > > ALGERIA > Yellow fever: A yellow fever vaccination certificate is required from > travellers over 1 year of age coming from infected areas. > Malaria: Malaria risk is limited. One small focus (P. vivax) has been > reported in Ihrir (Illizi Department), but this is isolated and access is > difficult. > Recommended prophylaxis: none. > > AMERICAN SAMOA > Capital: Pago Pago > Altitude: 10 m > Yellow fever: A yellow fever vaccination certificate is required from > travellers over 1 year of age coming from infected areas. > > Now I have a table in a MySQL db naming all those countries. The goal is to > extract the Yellow fever and Malaria line and put it into a mysql table > related to the countries. > > I saw that PHP has some good functions on text, but do u guys think this > could be done??? Doing it by hand could take allllloooong loooooong while. > > I am open for any idea! > > Thanx a lot for any help > > Cheers, Andy > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php