Populate dropdown box with number of row

[Anon]

I want to populate a dropdown box with the number of rows in a mysql database. The number of rows will always be changing. Can anyone help me out with this? I'm thinking I need to use mysql_num_rows, but i'm unsure of how to populate the dropdown box with (say there are 5 rows in the database) 1,2,3,4,5. Actually I think maybe I answered my own question. I guess I just have to make a counter that ad's one to the dropdown box until it gets to the mysql_num_rows number. Can anyone help me with the code for this? Thanks

[biggus]

Vocoder,
just make a for loop and generate a new option for each row...

<select>
<option value="0" selected>---------------------------</option>
<?
$SQL="select * from CARS where MODEL IS NOT NULL order by MAKE asc";
$result=mysql_query ($SQL, $connection) or die ("couldn't execute query<br>sql stmnt=$SQL");
$which=0;
while ($row=mysql_fetch_array($result)){
$which++;
?>
<option value="<?echo $which?>"><?echo $row['MAKE']?></option>
<?}
mysql_close($connection);
?>
</select>