posting this into a database

[mforan]

i want to post this raw data into the database....

orderID,typeID,charID,charName,regionID,regionName,stationID,stationName,range,bid,price,volEntered,volRemaining,issued,orderState,minVolume,contraband,accountID,duration,isCorp,solarSystemID,solarSystemName,escrow,

952056770,2865,1335668152,Sumihaza,10000060,Delve,60014949,YZ9-F6 V - Blood Raiders Assembly Plant,32767,0,3800000.0,35,24.0,2008-12-25 07:52:09.000,0,1,0,12267771,90,0,30004719,YZ9-F6,0.0,

952056981,2873,1335668152,Sumihaza,10000060,Delve,60014949,YZ9-F6 V - Blood Raiders Assembly Plant,32767,0,700000.0,30,27.0,2008-12-25 07:52:38.000,0,1,0,12267771,90,0,30004719,YZ9-F6,0.0,

952057400,2961,1335668152,Sumihaza,10000060,Delve,60014949,YZ9-F6 V - Blood Raiders Assembly Plant,32767,0,4000000.0,40,39.0,2008-12-25 07:53:29.000,0,1,0,12267771,90,0,30004719,YZ9-F6,0.0,

 

this is exactly what the raw data. my question is, is it possible to make the php change this data into a mysql format to be able to post into the database afterwards. kinda like a convertor i guess.

 

my mate is not sure how to do it, and does not know what output type this raw data is either.

 

[corbin]

http://dev.mysql.com/doc/refman/5.0/en/mysqlimport.html

 

 

Or

 

 

http://php.net/explode

 

 

You could either use that CLI utility to import it as CSV data, or you could use explode to make it into an array and then build insert statements.