[SOLVED] extracting instances of a string in an array

[Darkmatter5]

If I had an array created from a query of mysql, that returned a year column.  How can I list each instance of each unique year.  Example.

 

Table:

 

item_id    year

1            2008

2            2004

3            2008

4            2001

5            2004

 

how can I make a list that would look like this?

2001

2004

2008

[gaza165]

In your sql query just use group by

 

$sql = "SELECT year FROM database_name GROUP BY YEAR(year)";

[o3d]

or you could use :

 

SELECT DISTINCT year FROM tablename;

[Darkmatter5]

Thanks both for the input!