csv reader php

program to upload options data from sample file into mysql table below [login to view URL] has definitions of each line 1st page has form with upload file box it will insert into this table CREATE TABLE `options` ( `optionid` int(11) NOT NULL auto_increment, `StockId` int(11) NOT NULL, `optiondate` date NOT NULL, `expDate` date NOT NULL, `optionType` char(1) default NULL, `strike` double default NULL, `lastsale` double(10,2) NOT NULL, `volume` int(11) NOT NULL, `bid` double(10,2) NOT NULL, `ask` double(10,2) NOT NULL, `openInterest` int(11) NOT NULL, PRIMARY KEY (`optionid`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 For the first line A 110416C00025000,A,,,,,,0,25,16.85,18.2,0,2011 StockId is get from select StockId from StockSymbols where Symbol='A'; optiondate is 2011-03-16 from the file name [login to view URL] expDate is 2011-04-16 for the first line from 110416 optionType is C strike is 25.00 lastsale is blank which is 0 volume is 0 bid 16.85 ask is 18.2 openInterest is 0 for this line MGLN 110416C00050000,MGLN,,,,,1.7,0,50,0.0,2.6,11,2011 mysql> select StockId from StockSymbols where Symbol='MGLN'; +---------+ | StockId | +---------+ | 1427 | +---------+ 1 row in set (0.03 sec) mysql> StockId is 1427 optiondate is 2011-03-16 from the file name [login to view URL] expDate is 2011-04-16 for the first line from 110416 optionType is C strike is 50.00 lastsale is blank which is 1.7 volume is 0 bid 0.0 ask is 2.6 openInterest is 11