Re: Enum MySQL and PHP
| From: | Daniel Convissor | Date: | Thu, 03 Aug 2000 03:57:56 +0000 |
| Subject: | Re: Enum MySQL and PHP | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-9871@lists.php.net to get a copy of this message | ||
Heya:
Derick Schuetz wrote:
>
> I have an Enum field in a MySQL database. How can I populate an HTML
> dropdown list box with the Values for the Enum field?
Quick and dirty example. Modify for your needs.
<form>
<select name="State">
<?
$List = array("ny","nj","pa");
$Record = mysql_fetch_array($RecordSet, MYSQL_ASSOC)
while ( list(,$Val) = each($List) ) {
echo " <option value=\"$Val\"";
if ( $Val == $Record["State"] ) {
echo " selected";
}
echo ">$Val</option>\n";
}
?>
</select>
</form>
--
T H E A N A L Y S I S A N D S O L U T I O N S C O M P A N Y
More than just answers. Solutions. (SM)
http://www.analysisandsolutions.com/
4015 7 Av #4, Brooklyn NY 11232 v: 718-854-0335 f: 718-854-0409