dynamic table

[akaki]

😕
Hi Guyes,
I am trying to insert some data in the "order" table in database. But my data are not fixed. I mean, ther's may be 5 data in 1st order, but may be 7 data in 2nd order.... so I can't insert fixed number of data in order table. so how i can manage to create such kind of table?
And also i need help to write php code to insert data in that order table.
If any tutorial on this topics, please inform me & ofcourse if you have code, then provide me plz...
Thanks

[wilku]

That's what relational database is for. You create table items with item description (probably some product id, referencing to products table) and a foreign key, which will be the primary key from your order table. First you insert your order (without any items). Then you insert to the items table one product per row, giving order id as well. You end up with one row in order table and many rows in items table, that are connected with order id. Now you can have as many items assigned to one order as you wish.