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