thanks for your help Ray - not sure place to place that recordset though...
I've set the select list value to the Options Recordset ID :
<option value="<?php echo $row_rstGetOptions['option_ID']?>">
then created a recordset to pull in the posted value:
I've put it before the Add To Cart behaviour:
$colname_rstGetOption = "-1";
if (isset($_POST['option_ID'])) {
$colname_rstGetOption = $_POST['option_ID'];
}
mysql_select_db($database_hayward, $hayward);
$query_rstGetOption = sprintf("SELECT * FROM OPTIONS WHERE option_ID = %s", GetSQLValueString($colname_rstGetOption, "int"));
$rstGetOption = mysql_query($query_rstGetOption, $hayward) or die(mysql_error());
$row_rstGetOption = mysql_fetch_assoc($rstGetOption);
$totalRows_rstGetOption = mysql_num_rows($rstGetOption);
then set the add to cart code to bring in those recordset values
$ATC_itemName = "".$row_rstProduct['name'] ." - ". $row_rstGetOption['option'] . "";// column binding
$ATC_itemDescription = "";// column binding
$ATC_itemThumbnail = "";// column binding
$ATC_itemWeight = floatval("0");// column binding
$ATC_itemQuantity = "".$_POST["eCart1_1_Quantity_Add"] ."";// column binding
$ATC_itemPrice = "".$row_rstGetOption['price'] ."";// column binding