Hi Jason, I am still a little stuck on the recordset query, so just need an example to work on if thats possible. also if I am creating this recordset query to load in the correct shipping value based on country zone, delivery type and total cart weight then what would I need to put in for the ecart shipping rules (since I wouldnt need to use the ecart shipping rules weights as this is already determined in the recordset query right?
so just to recap I need to know how to create a recordset query based on the CountryLocationZone, ShippingOptionsType & ecart Total cart weight.
Also in the table for shippinglocation I have added an extra field called "ShippingCode" that will pass the country code to paypal (eg GB, US, FR etc).
and currently on my checkout page I have used a simple recordset to load all values of shippinglocation table to show all counties for the customer to select and a second recordset to load all values of shipping options so that UK customers can select which delivery type they want. it would also be nice to only display shipping options if a customer selects UK fromt he dropdown menu.
But first would like to get the recordsets sorted first.
Ived included the checkout.php files * a copy of the shipping tables in the database for reference. it be great if you could let me know how to construct the recordset to query what i need from the 3 tables. plus what shipping rules i need to create in the ecart object?