DB Based Shopping Cart to File

[cmptrwhz]

Hi All,

I have a unique issue and need some help please. I have a DB-based cart that puts a unique cartid into the DB to hold the items that a customer has added to their order. Then the system goes through and processes the order, totals the cart, etc.

Here is my issue:

I need to be able to at the end of the order, place into 2 different files the items that were ordered based on item# because the some items come from one supplier and some come from another, and both have given us the ability to input directly into their systems with a flat comma delimited file.

Can any one help or point me in the right direction?

Thanks for the help in advance.

Mike