The exact implementation differs with your database system, but as an
example for MySQL:
<select name="select" size="1">
<?php
$result = mysql_query($query);
while($row = mysql_fetch_assoc){
echo("<option
value=\"{$row['name_of_value_field']}\">{$row['name_of_description_field']}<
/option>");
}
?>
</select>
greetz,
Arnout
"Harlequin" <[EMAIL PROTECTED]> schreef in bericht
news:[EMAIL PROTECTED]
> Another day another conundrum.
>
> I have a form where one option is a dropdown menu. I'd like that menu to
> only have items in it that are actually available. Selecting the items
with
> a query is easy enough but I wondered if anyone could tell me where to
start
> wit the code.
>
> Am I using a for each again . . . ?
>
> Any help greatly appreciated.
>
> --
> -----------------------------
> Michael Mason
> Arras People
> www.arraspeople.co.uk
> -----------------------------
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
