OK, I solved one problem in that the price increment column hadn't been included in the recordset and so wasn't showing on the product details page. That's now fixed, however the price increment still isn't being passed to the cart page. I think there may be a bug in Dreamweaver as the problem seems to be when I try to update the Add to Cart behavior (second last step in the tutorial, "Add dynamic product options II"). When I follow the steps, it doesn't appear to do anything except add another option value, but as plain text rather than code. I already have this as my select menu:
<select name="VetProCart_1_Format_Add">
<option value="">Select a format..</option>
<?php
do {
?>
<option value="<?php echo $row_rsFormat['ProductOptionID']?>"><?php echo $row_rsFormat['OptionName']?> (+£<?php echo $row_rsFormat['OptionPriceIncrement']; ?>.00) </option>
<?php
} while ($row_rsFormat = mysql_fetch_assoc($rsFormat));
$rows = mysql_num_rows($rsFormat);
if($rows > 0) {
mysql_data_seek($rsFormat, 0);
$row_rsFormat = mysql_fetch_assoc($rsFormat);
}
?>
</select>
but when I update the eCart Add from Recordset Behavior as instructed in the tutorial, this is what it does:
<select name="VetProCart_1_Format_Add">
<option value="">Select a format..</option>
<?php
do {
?>
<option value="<?php echo $row_rsFormat['ProductOptionID']?>"><?php echo $row_rsFormat['OptionName']?> (+£<?php echo $row_rsFormat['OptionPriceIncrement']; ?>.00) </option>
<?php
} while ($row_rsFormat = mysql_fetch_assoc($rsFormat));
$rows = mysql_num_rows($rsFormat);
if($rows > 0) {
mysql_data_seek($rsFormat, 0);
$row_rsFormat = mysql_fetch_assoc($rsFormat);
}
?>
<OPTION value="<?php echo $row_rsFormatLookup['OptionName']; ?>" selected><?php echo $row_rsFormatLookup['OptionName']; ?></OPTION>
</select>
Note the extra OPTION (in caps, this is exactly the way Dreamweaver inserted it). I've tried removing that extra option, changing the recordset for the correct option to rsFormatLookup but nothing's working. Would you be able to take a look for me please? Access details in the PM field.