Thanks for that.I had that right but I'd chosen rsSizeLookuo instead of rsSize for my select list which gave me my problem.
I was going through to see why the price increment wasn't adding to my cart when I found this back in the ecart object
Instead of [Price]+[sizePriceInc] it reverts to this [Price] +[size]PriceInc and the same thing for this [Price]+[sizePriceInc] * [Quantity] it reverts to this ([Price]+[size]PriceInc) * [Quantity]
I've just changed the column from sizePriceInc to SizePriceInc and in the add to cart column bindings.
But the price increase still isn't adding to the cart . And in fact the product detail page is now redirecting to itself.
This is my add to cart code:
<?php
// WA eCart AddToCart
if (isset($_POST["eCart1_1_ATC"]) || isset($_POST["eCart1_1_ATC_x"])) {
$ATC_itemID = $_POST["eCart1_1_ID_Add"];
$ATC_AddIfIn = 0;
$ATC_RedirectAfter = "TESTshop_cart.php";
$ATC_RedirectIfIn = "";
if (isset($totalRows_rsSingle_product) && $totalRows_rsSingle_product > 0) {
$row_rsSingle_product = WAEC_findRecordMySQL($rsSingle_product, "productID", $ATC_itemID);
if ($row_rsSingle_product) {
$ATC_itemName = "".$_POST["eCart1_1_Name_Add"] ."";// column binding
$ATC_itemDescription = "";// column binding
$ATC_itemWeight = floatval("0");// column binding
$ATC_itemQuantity = "".$_POST["eCart1_1_Quantity_Add"] ."";// column binding
$ATC_itemPrice = "".$_POST["eCart1_1_Price_Add"] ."";// column binding
$ATC_itemConfig = "".$_POST["eCart1_1_Config_Add"] ."";// column binding
$ATC_itemlength = "".$_POST["eCart1_1_length_Add"] ."";// column binding
$ATC_itemInlet = "".$_POST["eCart1_1_Inlet_Add"] ."";// column binding
$ATC_itemImage = "".$_POST["eCart1_1_Image_Add"] ."";// column binding
$ATC_itemFourInchOption = floatval("".$_POST["eCart1_1_FourInchOption_Add"] ."");// column binding
$ATC_itemsize = "".$row_rsSizeLookup['OptionName'] ."";// column binding
$ATC_itemSizePriceInc = floatval("".$row_rsSizeLookup['OptionPriceincrement'] ."");// column binding
mysql_data_seek($rsSingle_product, 0);
$row_rsSingle_product = mysql_fetch_assoc($rsSingle_product);
}
}
$ATC_itemQuantity = floatval($ATC_itemQuantity);
if (is_numeric($ATC_itemQuantity) && $ATC_itemQuantity != 0) {
$eCart1->AddToCart($ATC_AddIfIn, $ATC_RedirectIfIn, $ATC_itemID, $ATC_itemName, $ATC_itemDescription, $ATC_itemWeight, $ATC_itemQuantity, $ATC_itemPrice, $ATC_itemConfig, $ATC_itemlength, $ATC_itemInlet, $ATC_itemImage, $ATC_itemFourInchOption, $ATC_itemsize, $ATC_itemSizePriceInc);
if ($ATC_RedirectAfter != "" && $eCart1->redirStr == "") {
$eCart1->redirStr = $ATC_RedirectAfter;
}
if (isset($_SERVER['QUERY_STRING']) && $_SERVER['QUERY_STRING'] != "") {
$_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF']."?".$_SERVER['QUERY_STRING'];
}
else {
$_SESSION['WAEC_ContinueRedirect'] = $_SERVER['PHP_SELF'];
}
}
}
?>
<?php
// WA eCart Redirect
if ($eCart1->redirStr != "") {
header("Location: ".$eCart1->redirStr);
}
?>
What am I doing wrong?
Phil