How Would You Structure This?

[eluser]xwero[/eluser]
I fail to see the problem there? In the table productlist table there is the current stock. And you substract it with the number of the items once an order is submitted. If you allow multiple items i think you best go for a select list or a spinbutton that only goes to the highest stock possible and you check the current stock before you confirm the order.