That displays all the fields from the database in a table on screen. They are all in text boxes, but only one of them is editable which is the quantity one. Example of last entry: (Qty, Code, Size, Desc)
0, 633445, 2.5kg, Peach Slices
NOW, the problem - when the user has enetered the quantity of everything they want - that needs to go into a different table called orders. The problem is that because all of the products have been loaded from SQL using loops it only ever remembers the last entry, as above!
The submit file is below: I have just used the same variable for testing purposes at the moment (code):
So - what do I require?? I need this submit file to enter EVERY product into the orders table, with the correct number in the qty column depending what the user has entered. Should I be using loops again?
I hope this all makes sense and somebody can help!
Last edited by u0754284; 04-17-11 at 08:56.
Reason: code quotes