how would thid be done?

[Henri]

hello, I want to retrieve the info from 2 fields in a table (mysql) and have one of the field's info be the <option> and the other be the value="". I got an idea on how I would do this just for entry, but I have more than one. here's an example:

<select name="something" size="1">
<option selected>Select link to edit:
<option value="value from database">name of link from database
<option value="value2 from database">name2 of link from database
<option value="value3 from database">name3 of link from database
</select>

how would I go about doing this?

thanx a lot

[diego25]

1. get the values from the database
2. loop through the result set
   2.1 output the HTML for each option

Diego

[Henri]

can you please tell me how to loopthrough the results?

thanx

[Sphynx]

$result = mysql_query("SELECT value,option FROM tbl_name");
echo "<select name=\"blah\">"

while ($line = mysql_fetch_array($result)) {
   echo "<option value=\"".$line['value']."\">".$line['option']."</option>"
}
echo "</select>"

[Henri]

thanx a lot man, I`ll try that as soon as I get home.