I have a recordset on the checkout page but the conundrum is as follows:
When I use the visitors ID value in the dynamic options to automatically choose the county on the checkout page it works but sends the country ID rather than country abbreviations (option value) so the Tax and Shipping formulas on the confirm page DON'T work.
When I use the value: VisitorBillCountryID it doesn't automatically choose the county but the Tax and Shipping formulas on the confirm page DO work. EG:
<select name="country" id="country">
<option value="" selected="selected" <?php if (!(strcmp("", $row_rsVisitor['VisitorBillCountryID']))) {echo "selected=\"selected\"";} ?>>Choose a country</option>
<option value="US" <?php if (!(strcmp("US", $row_rsVisitor['VisitorBillCountryID']))) {echo "selected=\"selected\"";} ?>>United States</option>
<option value="GB" <?php if (!(strcmp("GB", $row_rsVisitor['VisitorBillCountryID']))) {echo "selected=\"selected\"";} ?>>United Kingdom</option> ETC ETC
And at the bottom:
<?php
do {
?>
<option value="<?php echo $row_rsVisitor['CountryID']?>"<?php if (!(strcmp($row_rsVisitor['CountryID'], $row_rsVisitor['VisitorBillCountryID']))) {echo "selected=\"selected\"";} ?>><?php echo $row_rsVisitor['CountryName']?></option>
<?php
} while ($row_rsVisitor = mysql_fetch_assoc($rsVisitor));
$rows = mysql_num_rows($rsVisitor);
if($rows > 0) {
mysql_data_seek($rsVisitor, 0);
$row_rsVisitor = mysql_fetch_assoc($rsVisitor);
}
?>
Maybe a hand code the above from CountryID to VisitorID would work?