<options selected>

[mdienna]

I'm new to PHP and trying to build a project management application. I'm using <select> lists to insert some of the fields into a database.

I need to be able to retrieve these values from the database and set the matching <option> to SELECTED so that the values show up as the default.

Hope this is clear. Any help would be greatly appreciated.

[Anon]

Hi there,
There are a few ways that you could do this.
One way would be to do the following:

<select name="field_name">
<option<?PHP
if ($field_name == "") echo " SELECTED"
?>> ----------------------- Select ------------------------</option>
<option value="1"<?PHP if ($field_name == 1) echo " SELECTED" ?>>Name 2</option>
<option value="2"<?PHP if ($field_name == 2) echo " SELECTED" ?>>Name 2</option>
<option value="3"<?PHP if ($field_name == 3) echo " SELECTED" ?>>Name 3</option>
</select>

Hope that helps

[bretticus]

Believe I e-mailed this to you earlier when the post script on this forum was down....oh well, here is is again (maybe ;-)

<select name="id">
<?
$sql = "SELECT column FROM table";
$result = mysql_query($sql) or die("Invalid query");
while ($row = mysql_fetch_row ($result)) {
$sel = "";
if ($row[0] == $id){$sel = " selected";}
print "<option$sel>$row[0]</option>\n";
}
?>
</select>