How to create a dynamic drop down box

[DirtySnipe]

I have created a php form with dynamic drop down boxes in it which pull the options from a database. The boxes work fine and the data gets submitted fine but im having a problem getting the box to default to a record of my choice from the database. (record 1 = None).
Here is the code to what i have done.

<input maxLength="40" size="30" name="name"></td>
    </tr>
    <tr>
      <td width="286" height="22"><b>Person Involved:</b></td>
      <td align="left" width="365" height="24"><select name="person_involved">
 
        <?php
 

hesk_dbConnect();
$sql = "SELECT * FROM `hesk_involved` ORDER BY `name` ASC";
$result = hesk_dbQuery($sql);
while ($row=hesk_dbFetchAssoc($result))
{
    echo "
    <option value=\"$row[name]\">$row[name]</option>
    ";
}
 

?>
      </select></td>
    </tr>
 

Hope you guys can help me out as im pulling my hair out now.

[DirtySnipe]

Ok looks like were moving forward now on this but there is still a problem.

It is not sending the selected item from dropdown. It is looking for the select name of involved.

Here is the code so far, I hope you can help.

[PHP]<tr>
<td width="286" height="22"><b> Person Involved:</b></td>
<td align="left" width="365" height="24"><se lect name="involved" >

<?
hesk_dbConnect( );
$sql = "SELECT * FROM `hesk_involved` ORDER BY `name` ASC";
$result = hesk_dbQuery($s ql);
while ($row=hesk_dbFe tchAssoc($resul t))
{
$sel = $row['isDefault'] == true ? "selected='sele cted'" : "";
?>
<option <?=$sel?> value="<?=$row['name']?>"><?=$row['name']?></option>
<?
}
?>


</td>
</tr>[/PHP]

[DirtySnipe]

hahaha lol

Duuuu

i got the select name wrong at the start.

Sorry about that.

Thanks alot this works great.