[PHP-DB] Re: splitting CSV rows into multiple SQL inserts?

2005-06-22 Thread Vince LaMonica
I wanted to clarify my question from yesterday, as re-reading it, it sounds quite confusing. I have a CVS file that has order header *and* line item info on each line, like: 1110,6/20/2005,Jan Doe,123 Main St,,1,Book 1116,6/22/2005,Jim Smith,44 Here St,19191980,1,CD 1116,6/22/2005,Jim

Re: [PHP-DB] Re: splitting CSV rows into multiple SQL inserts?

2005-06-22 Thread Doug Hernandez
On 6/22/05, Doug Hernandez [EMAIL PROTECTED] wrote: I can't help but wonder why you're using the line_order field at all. Can't you nix it and count the number of records with each order# as a stored procedure or some such? It would make your entire order system easier. Also, you may think

Re: [PHP-DB] Re: splitting CSV rows into multiple SQL inserts?

2005-06-22 Thread Doug Hernandez
I can't help but wonder why you're using the line_order field at all. Can't you nix it and count the number of records with each order# as a stored procedure or some such? It would make your entire order system easier. Also, you may think about capturing that first row in its own list: $fp =