Only read unique values out of MySQL table

select all the values out of a MySQL Database that are UNIQUE:
$result = mysql_query("SELECT DISTINCT fieldNAME FROM tableName");

Reference: http://www.dreamincode.net/forums/showtopic6057.htm