problem with option price increment

using eCart4 and tutorial Product Options with eCart

I am having problem with my sizelookup recordset executing

mysql ---
$var1_rs_sizelookup = "-1";
if (isset($_POST['selectlength'])) {
$var1_rs_sizelookup = (get_magic_quotes_gpc()) ? $_POST['selectlength'] : addslashes($_POST['selectlength']);
}
$paramItem_rs_sizelookup = "-1";
if (isset($_POST['screenroom_1_ID_Add'])) {
$paramItem_rs_sizelookup = (get_magic_quotes_gpc()) ? $_POST['screenroom_1_ID_Add'] : addslashes($_POST['screenroom_1_ID_Add']);
}
mysql_select_db($database_connscreen, $connscreen);
$query_rs_sizelookup = sprintf("SELECT productoptions.optionpriceincrement, productoptions.itemoptionID, options.option_name, options.optiongroupID, optiongroups.optiongroup_name FROM options INNER JOIN productoptions ON options.optionID = productoptions.optionID INNER JOIN optiongroups ON options.optiongroupID = optiongroups.optiongroupID WHERE optiongroups.optiongroup_name = 'lengths' AND productoptions.itemoptionID = %s AND productoptions.item_ID = %s", GetSQLValueString($var1_rs_sizelookup, "int"),GetSQLValueString($paramItem_rs_sizelookup, "int"));
$rs_sizelookup = mysql_query($query_rs_sizelookup, $connscreen) or die(mysql_error());
$row_rs_sizelookup = mysql_fetch_assoc($rs_sizelookup);
$totalRows_rs_sizelookup = mysql_num_rows($rs_sizelookup);

select list populates properly from size recordset, but can't get the sizelookup recordset to work and carry the information to the cart.

Thanks for your help,
-Jim Balthrop

please post a copy of the page in a zip archive so i can see the recordset code in context.

attached is page

Thanks Jason,

I figured it out and got it to work properly.

I had my recordsets in the wrong place on the page.
To make it work, I put the colors and size recordsets within the repeat region in the body
and the sizelookup recordset which had the price increment info that carried to the cart, i put at the top of the page where the item recordset is.

glad to hear you found the problem.

Jason,

can you help me with the confirm page getting the correct information to PayPal Website Standard.

I added the size and sizPriceInc columns to the confirm page and they work properly

I am not sure the code to get that info to PayPal

Here is the current code that i think needs changing

if ((WA_eCart_FormatNumber($screenroom->DisplayInfo("Price") - (($screenroom->DisplayInfo("Price")/$screenroom->TotalColumn("TotalPrice")) * $screenroom->GetDiscounts()), false, 2) > 0)) {
?>
<input type="hidden" name="amount_<?php echo $screenroom_Index+1; ?>" id="amount_<?php echo $screenroom_Index+1; ?>" value="<?php echo WA_eCart_FormatNumber($screenroom->DisplayInfo("Price") - (($screenroom->DisplayInfo("Price")/$screenroom->TotalColumn("TotalPrice")) * $screenroom->GetDiscounts()), false, 2) ?>" />

Never mind, Jason

I got it working

I changed
if ((WA_eCart_FormatNumber($screenroom->DisplayInfo("Price") - (($screenroom->DisplayInfo("Price")/$screenroom->TotalColumn("TotalPrice")) * $screenroom->GetDiscounts()), false, 2) > 0)) {
?>
<input type="hidden" name="amount_<?php echo $screenroom_Index+1; ?>" id="amount_<?php echo $screenroom_Index+1; ?>" value="<?php echo WA_eCart_FormatNumber($screenroom->DisplayInfo("Price") - (($screenroom->DisplayInfo("Price")/$screenroom->TotalColumn("TotalPrice")) * $screenroom->GetDiscounts()), false, 2) ?>" />


to
if ((WA_eCart_FormatNumber($screenroom->DisplayInfo("Price") - (($screenroom->DisplayInfo("Price")/$screenroom->TotalColumn("TotalPrice")) * $screenroom->GetDiscounts()), false, 2) > 0)) {
?>
<input type="hidden" name="amount_<?php echo $screenroom_Index+1; ?>" id="amount_<?php echo $screenroom_Index+1; ?>" value="<?php echo WA_eCart_FormatNumber($screenroom->DisplayInfo("truePrice") - (($screenroom->DisplayInfo("Price")/$screenroom->TotalColumn("TotalPrice")) * $screenroom->GetDiscounts()), false, 2) ?>" />


thanks for your help, as always