Stopping repeat entries in select box

[tonytrev]

Hi,

I have a mySQL table which can have the same value on more than one row in a 'category' field.

Is there a php way of creating a select box filtering out repeat entries, so that it is only populated with a single instance of each category in the table?

Thanks.

[Lars_Berg]

$q="select distinct category from t";

[tonytrev]

Got too wrapped up in trying to be clever with the php and missed th obvious!

Many thanks

Tony