customer order in depth details

this is for customer-order-details.php page.

Here complete order details are shown.
I added new field in orderdetails table ie. shipping.
shipping from orderdetails stores INT.

Another Table: ShippingStatus has id, name.
So in details page i created new RS as attached & colname1 value is : $row_WADAorderdetails['DetailOrderID']
Now results seem to work but when there are more than 1 order in orderdetails then it doesn't seem to appear well.

May i know how exactly it is done?
All results shown are same when there are more than 1 orderdetails.

Do i need to go through this? http://www.webassist.com/tutorials/Display-nested-recordsets

Now Problem here is, i don't have complete databridge, i got dataassist, securityassist, ue & ecart.


Regards

Yes, the nested recordset tutorial will help, it doesn't matter that you don't have data bridge, the concept is still the same.

basically you are just creating a master detail page set.

the master page shows the orders, with a link to the order details page, the link passes the orderID as a URL variable:
orderdetails.php?OrderID=12

on the order details page, you create a recordset that filters the OrderID column by the passed URL variable.