How to get list of other values in a field

[Anon]

Hello, I'm creating an application in PHP to access some data in mySQL. Pretty basic idea, not much manipulatipn of the data, just displaying it. I'd like to have a page come up with a list box that has all of the values in the field throughout the database. It's hard to explain, but say the numbers 1 through 10 are are used in a field in a 2000 record database. Of course there are going to be duplicates, but I want to populate the list box with just the unique values (1 through 10). Any help anybody could provide would be appreciated. <a href="mailto:[e-mail]">Ed</a>

[Anon]

$result = mysql_query("SELECT DISTINCT fieldname from tablename", $db);
print '<select name=somename>';
while ($myrow=mysql_fetch_array($result)) {
printf('<option value="%s">%s', $myrow["fieldname"], $myrow["fieldname"]);
}
print '</select>;