Saving data from loop statements...

gabe8496

Hello, new to this forum.

Seeking some help on a site i'm working on.

Our company acquired a software for order processing we do. I am in the midst of trying to format it somewhat and i'm coming across a situation i'm not familiar with.

In this code, there is a loop statement that adds the quantity of SM, MD, LG, 1X, 2X and 3x and displays a grand total.

I am needing to create a query that will insert each size into 1 record, sorta like this:

Record1: Qty, BaseID, CustomText, Size,Price, Extended Price

THis will need to be done with each size that the user has added to the cart.

I am not displaying any info now, as i am unser what is needed but if someone can point me in the right direction, it will be greatly appreciated. I will post whatever code is needed.

Thanks!

kburger

So what's the question again? Just insert the data. Is there something I'm missing here?

gabe8496

sorry for the confusion. The way it is righ now, the whole order is inserted in the db in one field called html. I need to have the order broken down into different entries into the database. For instance, if the order has 5SM, 10MD, 10LG, I need the 5SM inserted as one record in the db, which will include the qty, baseid, customtxt, size,price,extended price and the 10MD will be a seperate entry with the same info (pertaining to that size) and the 10LG will be another record.

But the problem i'm encountering is how do i go about creating a query that will do that. I assume I'd have to do some sort of loop that will check how many items are in the cart and add each item as a record in the db.

That is where i am stumped.

kburger

Well, the easiest way would be to do your inserts each individually in the loop that you mentioned in your previous post. If you wanted to, you could do multiple inserts with a single query, but that's not really necessary.

That's about all I can tell you without seeing some code. I still don't really see where the problem lies.