Hi all,
I am stuck on a page within my site. It is an admin page where the administrator can view a customers order, which comes from the orderinfo table, and the items and the quantities they've ordered, this comes from the orderline table.
I loop through (using repeat region) the items they ordered, and this works fine, showing each item, its cost etc, and using this I can work out the total for the order.
The problem I have is updating the orderline table. I want to give the administrator the ability to update the number of items the user purchases. But because I have looped through the orderline table to get these items, it will only update the last value that is shown.
Is there something I can use to loop through the insert statement to get every quantity to update in the orderline table? Or is there a function on Dreamweaver that I should be using?
Thank you for your help
sipps
I am stuck on a page within my site. It is an admin page where the administrator can view a customers order, which comes from the orderinfo table, and the items and the quantities they've ordered, this comes from the orderline table.
I loop through (using repeat region) the items they ordered, and this works fine, showing each item, its cost etc, and using this I can work out the total for the order.
The problem I have is updating the orderline table. I want to give the administrator the ability to update the number of items the user purchases. But because I have looped through the orderline table to get these items, it will only update the last value that is shown.
Is there something I can use to loop through the insert statement to get every quantity to update in the orderline table? Or is there a function on Dreamweaver that I should be using?
Thank you for your help
sipps
