Hi Guys,

I have a csv file. I use a CSVReader to get data of the file.

in the first column I have an order number. this is the process:

1. Use the order number and make an Entry into an Category table.
2. Get the last insert if and store in a variable
3. Loop through the csv file and check where the order number equals the current order number and then create items in an item table using the last insert id as a foreign key.

How should I do this. Should I use another csv reader to handle the item creating. please help