eCart only one Size Option Price showing in cart from detail page
Basically online store sells two types of Clocks in two sizes/prices with numerous image options
Clock Type One -- Size large $129, Size small $89
Clock Type Two -- Size large $129, Size small $89
Then there are options for images printed on each item.
Have setup first products page for Type selection.
Then redirect to page to select image Option.
Then redirected to detail page where Size is selected from dynamic menu and then added to cart
Database tables are setup
clock_type: ClockTypeID, ClockType, ClockImage
clock_size: ClockSizeID, ClockSize, ClockPrice
options: OptionsID, ClockTypeID, ClockSizeID
clock_graphic: ClockGraphicID, ClockGraphicName, ClockGraphicImage, ClockTypeID
clock_options: ClockOptionID, ClockGraphicID, OptionID
I am having a hard time working out how to setup the Price for the shopping cart.
I have a recordset rsSize connected to table clock_size for the eCart itemPrice. That is the only table that has the clock prices because price is based only on Size
$ATC_itemPrice = floatval("".$row_rsSize['ClockPrice'] ."");// column binding
and a dynamic menu for the Size select
<select name="eCart1_1_Size_Add" id="eCart1_1_Size_Add">
<option value="">Select A Size</option>
<?php
do {
?>
<option value="<?php echo $row_rsSize['ClockSize']?>"><?php echo $row_rsSize['ClockSize']?></option>
<?php
} while ($row_rsSize = mysql_fetch_assoc($rsSize));
$rows = mysql_num_rows($rsSize);
if($rows > 0) {
mysql_data_seek($rsSize, 0);
$row_rsSize = mysql_fetch_assoc($rsSize);
}
?>
</select>
Problem is, on the shopping cart page the price is always displayed for the large item (first in select list). The description shows the correct item from the dynamic menu label. Screen grabs attached
Obviously I am missing a connection somewhere to pass the correct price to the shopping cart....?