Order management without data assist?

Can anyone help with a basic setup for order management without data assist? I have the SQL statement to pull all the data but I need help with laying it out in a table to view the basic overview of the order and in the order detail page would have the entire detail.

If there are any tutorials or docs out there that would be great.

Thanks,
Tim

How are you planning to view the orders ?

Are you looking to have a table with a list of the orders, with each row having a link to the order details ?

Start with the orders table, if you have the recordset already, just create a table with 2 rows and the appropriate number of columns, with an extra column for your links
the link column should contain a link to your order details page, using the orderid as the url parameter

the first row contains the column headers
the second row contains the recordset fields.

once these are in place, select the whole second row and add a repeat region server behavior to it, which will give you a list of all of the orders.

the table on the order details page will be created in the same way, but the recordset will be based on the order details table, filtered by the orderid from the url parameter

Thanks, Craig!

I would like to have a page that will display the orders most current on top, when you click on the order number it would bring you to the detail page.

I tried this once before and if the order had four items there were four line for the same order on the first page and when you went to the details page it only had detail for one item.

I'm still learning PHP/MySQL if you can point me to any tutorials or examples that would be great.

Thanks,
Tim

a good start would be

ecommerce-database/

there should be plenty of tips here.

for php, try php.net/ or PHP/

there are some great books by David Powers if you want to do some reading