right...first bug... it seems that if i add the same product the TotalWeight seems fine in calculating the cost...however if i add a different product then the weight remains the same.
with the code you provided earlier it wasnt producting the results fromt he recordsets...however if i switched the Where clause around it work...
WHERE paramCartWeight >=DeliveryWorldMin AND paramCartWeight <= DeliveryWorldMax
In addition in I had to use for the runtime value : $_GET['TotalWeight'] (got this from another thread due to an error that was displaying: Fatal error: Can't use method return value in write context in C:\Server\www\lostsheep\checkout.php).
and added <?php $_GET['TotalWeight'] = $SheepCart->TotalColumn("TotalWeight"); ?> before the recordset so i can use that $_GET.
so not sure if it was that code that is causing the current bug. its odd. Im attaching the checkout.php file so see if there is anything from that thats obvious....
if you want to test the bug you can view the website here: (on the checkout page I have included code to display the current weight for reference.
also added some session display code at the bottom in case needed.
so just add a few random products to see the bug of TotalWeight not performing correctly on different products (yet it works on a single product with many qualities of that product) etc: lostsheep/
I hope its an easy mistake I done :)