Hi Jason, well I have been going around in circles with that last issue working..with no success: heres the run down:
(on both my main products page and voucher page I altered the code for:
$ATC_itemShippingType = "".$row_ItemDetail['ProductShippingType'] ."";// column binding
(from the previous floatval code)
when I go to the confirm page (before it loads up) i get the error : Unknown column 'Standard' in 'field list'
so now im lost.
I must be going about it all wrong.
as currently to recap my coding:
I have a dedicated gift voucher page that passes in the data from the recordset (Where ProductID = 52) (this is also odd as I had altered the code to do a better Where clause but it doesnt seem to save it so goes back to original recordset where clause).
..but for testing purposes for now it it seems to grab the data. so when I add to cart I wanted the ecart shipping rule to do a comparison to see if "ProductShippingType = voucher (this value is stored in the products record). and if its true then the shipping is set to 99p.
however IF a "standard" product is also added to the cart (standard is a different value stored in the same field in my products table under ProductShippingType) then when the customer gets to the Checkout page then they have the choice to select a radio button to select the new shipping cost which values are pulled from a recordset and stored as a session variable - so this then gets checked in the ecart shipping rules.
the main principle for the above is that the customer doesnt pay 99p + regular shipping cost if they purchase different products. they only pay 99p IF they only buy vouchers. bt then the cost of the main shipping costs are all stored in a database so client can change the values at will.
I feel I need to start from scratch. but hoping im just missing a small bit of logic somewhere.
Chris