order details in admin
I've built my admin section using DA and it's working fine.
Struggling a bit with the SQL to pull in an orders details.
I've got the default recordset by DA and then created a new recordset using:
SELECT *, DetailPrice * DetailQuantity AS lineTotal
FROM orderdetails, orders
WHERE orderdetails.DetailOrderID = colname
colname = $_GET['OrderID'] (given that OrderID is already passed into the page)
that's not working sadly.