I added the error coding and there was no result when I clicked Add to Cart. And still no redirect. I have checked the eCart Add from Recordset yet again and in both places (General and Bindings) the redirect value is set to cart.php which is in the same directory as the detail_page.php
As for the Color OptionName showing instead of the ProductOptionID. I think I followed correctly, see manually changed code noted below. The correct name is now showing in the shopping cart. I did not open and change any recordsets or server behaviors.
This is the code from the detail page for the color select list
<select name="eCart1_1_Color_Add">
<option value="" selected <?php if (!(strcmp("", $row_rsColor['OptionName']))) {echo "selected=\"selected\"";} ?>>Select Color</option>
<?php
do {
?>
<option value="<?php echo $row_rsColor['NOTE:changed ProductOptionID to OptionName']?>"<?php if (!(strcmp($row_rsColor['ProductOptionID'], $row_rsColor['OptionName']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsColor['OptionName']?></option>
<?php
} while ($row_rsColor = mysql_fetch_assoc($rsColor));
$rows = mysql_num_rows($rsColor);
if($rows > 0) {
mysql_data_seek($rsColor, 0);
$row_rsColor = mysql_fetch_assoc($rsColor);
}
?>
</select>