I'm trying to understand how this work

[derekburrows]

I created a page in Dreamweaver but couldn't get it to work easily on a remote server so I started over and created my database in phpmyadmin and almost everything is working. In Dreamweaver I created a drop down menu of 8 products with a recordset called type and even though I recreated that recodset in phpmyadmin there is something missing that I don't understand and need your help.
Here is the code from the Dreamweaver document. In the database there is a table called type. How can I connect this dropdown menu to that table?

?>
<option value="<?php echo $row_rsType['type_id']?>"><?php echo $row_rsType['type_id']?></option>
<?php
} while ($row_rsType = mysql_fetch_assoc($rsType));
$rows = mysql_num_rows($rsType);
if($rows > 0) {
mysql_data_seek($rsType, 0);
$row_rsType = mysql_fetch_assoc($rsType);
}
?>

Thanks

[laserlight]

You could run a query to select those 8 products, then iterate over the result set in a loop to display each menu option.

[derekburrows]

How do I do this? Again remember I'm new to this.

Thanks