Yes. I think at this point you should probably just delete the old repeat region code and apply the MySQLi repeat region manually in its place.
So remove the first instance of the line:
<?php do { ?>
and then remove the lines:
<?php mysql_free_result($ProductOptions); //mysql_free_result($OptionGroups); ?>
<?php } while ($row_OptionGroups = mysql_fetch_assoc($OptionGroups));
mysql_data_seek($OptionGroups, 0);
$row_OptionGroups = mysql_fetch_assoc($OptionGroups);?>
and select the code in-between and apply the mysqli repeat region using the OptionGroups recordset.
Then it looks like you also have a dynamic select list that wasn't updated to MySQLi. To fix that, delete this code:
<?php do { ?>
<option value="<?php echo $ProductOptions->getColumnVal('OptionID')?>"<?php if (!(strcmp($lastSel, $ProductOptions->getColumnVal('OptionID')))) {echo "selected=\"selected\"";} ?>><?php echo $ProductOptions->getColumnVal('OptionName')?> <?php echo ($ProductOptions->getColumnVal('OptionIncrement')?" (+ £".(number_format($ProductOptions->getColumnVal('OptionPrice'),2)).")":""); ?></option>
<?php
} while ($row_ProductOptions = mysql_fetch_assoc($ProductOptions));
$rows = mysql_num_rows($ProductOptions);
if($rows > 0) {
mysql_data_seek($ProductOptions, 0);
$row_ProductOptions = mysql_fetch_assoc($ProductOptions);
}
?>
Then highlight the select list and add dynamic attributes from the properties window to make the select list dynamically populated from the ProductOptions recordset. Just choose any column for the option title and value.
Once it is back on the page, then delete the <option> tag added and put back in your custom one by copying and pasting the value from before:
<option value="<?php echo $ProductOptions->getColumnVal('OptionID')?>"<?php if (!(strcmp($lastSel, $ProductOptions->getColumnVal('OptionID')))) {echo "selected=\"selected\"";} ?>><?php echo $ProductOptions->getColumnVal('OptionName')?> <?php echo ($ProductOptions->getColumnVal('OptionIncrement')?" (+ £".(number_format($ProductOptions->getColumnVal('OptionPrice'),2)).")":""); ?></option>
I think that should fix the page.
