Import url information into mysql with php

Hi

I have a little problem . Could you help me to import all informations from url :

ftp://tgftp.nws.noaa.gov/data/observations/metar/cycles/00Z.TXT

into mysql table .

for example :

2010/06/17 23:55
KFDW 172355Z AUTO 00000KT 10SM CLR 33/17 A2996 RMK AO1

1er row : 2010/06/17 23:55
2 : KFDW
3 : 172355Z
4: AUTO 00000KT 10SM CLR 33/17 A2996 RMK AO1

thanks

 

Create your database. Create tables with columns for what you refer to as rows.

In PHP then: Open the site url like a file. Read the data into an array. Parse the array writing the desired values to the database.

Study intensely at php.net and mysql.com to learn the programming to do all this.

Or hire someone to do it.