A simple dropdown question

[mmarif4u]

Hi all,
I have drop down populated from database table, which is working fine.
I want to add another value to the drop down, but not from table. Which will be called "All", i can do that from table. But i don't want that. Just want to add it statically.
Any ideas...

Here is the code:

<select name='id'>
<?php
$sql = mysql_query("select * from table where code='sm' order by id asc");
while($row = mysql_fetch_object($sql)){
if($id == $row->id){ 
echo "<option value='$row->id' selected='selected'>$row->id</option>";
}
else
{
echo "<option value='$row->id'>$row->id</option>";
}
}
?>
</select>

Thanks.

[oddz]

<select name='id'>
    <option value="0">All</option>
<?php
$sql = mysql_query('select * from table where code=\'sm\' order by id asc');
while($row = mysql_fetch_object($sql)) {
     echo '<option value=',$row->id,'',($id == $row->id?' selected=" selected"':''),'>',$row->id,'</option>';
}
?>

[mmarif4u]

Gr8.
Thanks oddz.