Forum Moderators: mack
the code
<select name="people">
<option value="">> select the person</option>
<?php
do {
?>
<option value="<?php echo $row['id']?>">> <?php echo $row['firstname']?> <?php echo $row['lastname']?></option>
<?php
} while ($row = mysql_fetch_assoc($people));
?>
</select>
the html produced
<select name="people">
<option value="">> select the person</option>
<option value="">> </option>
<option value="6">> tom smith</option>
<option value="4">> james smith</option>
<option value="1">> john smith</option>
<option value="3">> joe smith</option>
<option value="2">> helen smith</option>
<option value="5">> tom jones</option>
</select>