insert array?

[viveleroi0]

I have several product fields being posted a php script from a form, and I have one field in the database to add those fields too... basically condensing several fields into one in another table...

How would I do that? Would I use some sort of array to group them together, and then INSERT that array variable name into the other table?

[Pig]

Sounds like poor database design. Typically you shouldn't have to store an array. Usually when a situation like this comes up, you are better served with a seperate table to hold the items. If you can tell us exactly what you are doing, we could better help you.

[viveleroi0]

Each time a user adds a product to their cart, in the CARTS table, a new entry is made with their UserID, the product name, and the price.

When they send the final order, the checkout, the pages and email confirmations combine all order associated with their ID, using SELECT * FROM CARTS WHERE UserId=UserID type deal. Then, the results are displayed using a while loop.

Now, I am trying to add in functionality to add these orders to a seperate orders table. But, the product names and prices coming from the CARTS table and usually coming from more than one row. I want to condense the orders into one variable, which I assume would be done with an array.

Basically, condensing the CART results so that I can add them into the same ORDER insert, because I want 5 different orders in the db for one person... does that make sense?

[Pig]

Well, you have more options if you keep them out of an array. All you would have to do is insert a row for each of the original rows, basically mirroring the other table. Then you can still access the data as an array if you need to.

If you have your heart set on using an array within the table, checkout the implode and explode functions. That allows you to store an array in a string format.