Filling in a <select>

[Anon]

I want to fill in a dropdown box <select> using php. I plan to iteratively pull info from my db and create the strings that will go into the select. HOw can I do the creation of the <select> using PHP?
Ed

[[deleted]]

<extremely sarcastic>
Um...
echo '<select name=this>';
echo '<option value=bla>';
echo '</select>';
or is that too conventional?
</extremely sarcastic>

[Anon]

Here's an example where I retrieve dates from a table, create the select list, and display the date in a more readable format for the user.

++++++++++++ snip +++++++++++++++

while (is_array($date_array))
{
print("<option value=\"");
print($date_array["next_date"]);
print("\">");
$year = substr($date_array["next_date"], 0,4);
$month = substr($date_array["next_date"], 5,2);
$day = substr($date_array["next_date"], 8,2);
print("$month/$day/$year");
if ( ifx_num_rows($datesCR) == 5) / Stop after getting 5 dates /
{
break;
}
$date_array = ifx_fetch_row($datesCR, "next");
} / end while /
print("</select>\n");

[reagent]

<select name="name">
<? while ($row = mysql_fetch_array($result)) { ?>
<option value="<?= $row['data_val'] ?>"><?= $row['data_val'] ?></option>
<? } ?>
</select>

hope that puts you on the right path

[Anon]

<annoyed at being talked down to>
Conventional, yes, helpful, no. I guess I did not make my need clear in my original posting. What I want to do is use PHP and mySQL to create the <select>, pulling information from the DB that will go into the <select> options....
</annoyed at being talked down to>

Ed

[Anon]

Thanks...I'll give that a try.
Ed

[Anon]

Thanks...I'll give that a try.
Ed