Showing multiple order details on one page
I have a shopping cart system that pretty much follows the standard cart & checkout in eCart 5. It uses a users table, order table and order details table. I've generated all the proper backend pages with DataAssist/Data Bridge and am able to view Order Details in the backend one at a time.
My client wants to be able to click a button to load all unprocessed orders onto a single page for printing purposes, then once printed click a single verification that they have been printed OK and have all those orders 'archived'.
I know you can't give me a step by step, but can you give me some general direction on how to (A) pull multiple order/orderdetail records all on one page. The current detail page pulls it with two different queries, but that won't work for multiple orders on one page. Secondly, (B) the general approach to take every order in that result and change one field, like a 0 to a 1, to indicate the order has been processed.
Thanks. Any direction would be appreciated.