Mark default item selected in select box in form

[carisi_2000]

I have two tables, one is for the user, one for department. In order to add a new person to the faculty list, the editor fills out a form which includes this select box in which he selects the department from a drop down box, and it inserts the department id (deptid) into the user table. I then list all of the faculty with a link to edit their info. When the link is clicked the form is shown with all the previous data entered populating the correct fields with the exception of this select field, which is still on the default option. Any ideas?

<SELECT NAME="deptid" SIZE="1"><?
while ($myrow2 = mysql_fetch_array($result2))
{
echo "<option value=".$myrow2["deptid"].">";
echo $myrow2["department"];
echo "</option>";
}
?>
</select>

This script is designed to ins

[nemonoman]

use an "if"statement in your loop and add the attribute "selected=TRUE" to your HTML when the member's dept. is read from the database.

[morphy_6deex]

i dont understand but i assume that u meant that a defdeptid is set so:

<?
$defDeptId = $something;
?>
<SELECT NAME="deptid" SIZE="1"><? 
while ($myrow2 = mysql_fetch_array($result2)) 
{ 
echo "<option value=".$myrow2["deptid"].(($defDeptId==$myrow2["deptid"])?" selected ":"").">"; 
echo $myrow2["department"]; 
echo "</option>"; 
} 
?> 
</select>