Upload CSV to database script

[legal-medium]

Hi all,

I need to upload a .csv formated file to a database

My .csv file looks like this

"chris", "Jones", "851 Geary Blvd", "San Francisco", "CA", 94109, 28, 2003-09-10

My Database looks like this

f_name | l_name | address | city | state | zip_post | age | date

So I need an algorythym where I can upload the file via <input type="file" name="customerlist.csv"> and process the information to be inserted into the database.

Thanks for your help in advance

Additional Server Information

php 4.0.x
mysql 4.x
Red Hat 7.3
Apache Web Server

[bastien]

read the manual there is a function called fgetcsv[url]

reads all data into an array by line...then simply insert into db