Hi Jason, thank you for replying.
I would not of guessed that eCart would output something different than SA but thank you for the heads up. i will change this over.
In regards to the order history, I followed the Displaying Relational Table Data with Plugins video tutorial on Order history and Order details. This seems very straight forward if i was implementing it as part of the Back end Admin but not so if as i am wanting to to use it for the client side admin.
Would you suggest that i follow the Kurt's Tutorial for implementing order history.
My order history page is orders_detail.php
SQl for that page is
SELECT OrderID, OrderAmount, OrderShipName, OrderShipAddress, OrderShipAddress2, OrderCity, OrderState, OrderZip, OrderCountry, OrderPhone, OrderFax, OrderShipping, OrderTax, OrderEmail, OrderDate
FROM orders
WHERE OrderID = ParamOrderID AND OrderUserID = SecurityAssist_UserID
are you suggesting that i change the above to
SELECT OrderID, OrderAmount, OrderShipName, OrderShipAddress, OrderShipAddress2, OrderCity, OrderState, OrderZip, OrderCountry, OrderPhone, OrderFax, OrderShipping, OrderTax, OrderEmail, OrderDate
FROM orders
WHERE OrderID = ParamOrderID AND OrderUserID = SecurityAssist_UserID
Jonathon