order management

I have gone through the wizard to create my detail pages but have a few issues. How can I get my order management pages to display one line for an order. For example if order 111 ordered four items there are four lines for order 111. Also I would like to have the detail combine the orders and orderdetails table which I have my sql statement saying select * from orders, orderdetails where orders.detailID = orderdetails.orderDetailID. This gets me that data I want I just need to know how to sort it like the question above.

Thanks,
Tim

If you want to show the order, then make sure to select the order table (not the order details table). and on your detail page, you will add an additional query to get the entries from the order detail page.

Let me know if I did not answer your question correctly.

Dani,

I put in what you suggested and for the most part its working, however on the details page when I try to display the details it seems like its not matching the orderID's. If the last order in the DB is 111 I think its displaying the order details of order 1. I'm attaching my two pages hopefully you can offer some insight.

Thanks,
Tim

Looking at the order detail page, the second record set might need to be changed to:

$query_WADAordersDetail = sprintf("SELECT * FROM orderdetails, orders WHERE DetailOrderID = %s", GetSQLValueString($ParamOrderID2_WADAordersDetail, "int"));

and where you are displaying the name and the description you could apply a repeat region server behavior to display the individual items.

Dani,

I'm working on getting up to speed on PHP, based on my code could you supple an example for a repeated region?

Thanks,
Tim

In Dreamweaver open the Server Behaviors panel (Window -> Server Behaviors), and then select the region you want to repeat. In your case, you will need to select the tr tag, and then click the + button from the Server Behaviors panel and select Repeat Region. In the repeat region window select the record set and select all records and click OK.

Her is an example:

?php do { ?>
<tr>
<td>&nbsp;</td>
<td>&nbsp;</td>
</tr>
<?php } while ($row_Recordset1 = mysql_fetch_assoc($Recordset1)); ?>

Thanks Dani,

Can you have a look at the details page and help me understand why the items and item description are not displaying on the details page?

Thanks,
Tim

Your sql is not right.

Have you seen the tutorial that we have on the eCart support page for creating order history pages:
creating_order_history.php