Preventing duplicate dynamic list box items

[Lynne]

I have a dynamic list box pulling it's contents from a Datebase. Example: class list. Several classes are listed mulitiple times because they appear multiple times on the schedule. Is there a bit of php code I can add to the following so duplicates are not included in the list:

<option value="<?php echo $rs_getcourses->Fields('class')?>"><?php echo $rs_getcourses->Fields('class')?>

[The_Chancer]

You could push all the variables into an array and use array_unique.....

[slak]

...or you could SELECT DISTINCT(field) in your SQL statement.

[Lynne]

Being limited on my coding experience I've tried the following:

SELECT DISTINCT id, type, start_date, course_num, catagory, class, location, location_long, time
FROM all_courses
WHERE catagory = 'colname'

and this:

SELECT DISTINCT (class) id, type, start_date, course_num, catagory, class, location, location_long, time
FROM all_courses
WHERE catagory = 'colname'

....but am still getting duplicate classes in my dropdown list. Is there something I'm missing or wrong placement?

[Lynne]

SELECT DISTINCT class
FROM all_courses
WHERE catagory = 'colname'

this worked! Thanks all...