<?php
$rsREGIONS = new WA_MySQLi_RS("rsREGIONS",$csdbmysqli,0);
$rsREGIONS->setQuery("SELECT TMSAregions.tmsaregionID, TMSAregions.tmsaregion, TMSAregions.tmsamapsectionID, TMSAregions.tmsacountryID, TMSAcountry.tmsacountry FROM TMSAregions INNER JOIN TMSAcountry ON TMSAregions.tmsacountryID = TMSAcountry.tmsacountryID ORDER BY TMSAregions.tmsacountryID ASC, TMSAregions.tmsaregion ASC");
$rsREGIONS->execute();
?>
When I test that recordset in DW it displays the countryID and the country.
Ray, I just spotted single quotes around those values:
Originally Said By: Ray Borduin
php:
<option value="<?php echo($rsREGIONS->getColumnVal("regionID")); ?>" data-country="<?php echo($rsREGIONS->getColumnVal('country')); ?>" data-country-id="<?php echo($rsREGIONS->getColumnVal('country')); ?>"><?php echo($rsREGIONS->getColumnVal("region")); ?></option>
Should have been:
<option value="<?php echo($rsREGIONS->getColumnVal("regionID")); ?>" data-country="<?php echo($rsREGIONS->getColumnVal("tmsacountry")); ?>" data-country-id="<?php echo($rsREGIONS->getColumnVal("tmsacountryID")); ?>"><?php echo($rsREGIONS->getColumnVal("region")); ?></option>
That will teach me to cut and paste!
How do I get the <span id="showCountry"></span> value into the value of a form field?
