Select unique from table

[brooky]

Hi I have...

$select = mysql_query("SELECT option_id FROM store_options WHERE product='$product'");

How can I make it only select unique option_ids from the table.

e.g. $select = mysql_query("SELECT unique(option_id) FROM store_options WHERE product='$product'");

At the moment this gives me:

2
2
2
3
3
4
5
8
3
3
etc..

when I need...

2
3
4
5
8

Thanks guys 🙂

[YappyDog]

SELECT distinct option_id FROM store_options WHERE .......

[brooky]

Thank you I have been recking my brains for hours trying to remember that. 🙂