[RESOLVED] Need help with query

[grantus]

I know this is probably a simple solution, yet I'm scratching my head over this one.

I have let's say 30 entries in my database, all of them have an entry in the date column. It ranges from 2003 to 2006. What I want to do is display only the year, in order like this:

-2003
-2004
-2005
-2006

Of course with a regular query, it shows ALL the years. So for example, it will show 2003 a few times, 2004 a few times, etc. How would I limit it to showing each year only once?

Thanks in advance.

[vaaaska]

GROUP BY year (and certainly ORDER it accordingly too).

[grantus]

Well since I have the date in this format: Y-m-d, how would I get just the Y?

I tried GROUP BY but it shows how many times each year was used. For example, I have this date 2003-04-03 a few times then I have 2003-06-05 a few times. So when I used GROUP BY it showed '2003' twice. If that makes any sense.

Thanks.

[Installer]

$query = "SELECT YEAR(date_column) AS year FROM my_table GROUP BY year ORDER BY year";

[grantus]

Thank you! That query works great. Then I just did an echo on the year and it's fine.

Thanks for the help.

[bradgrafelman]

Don't forget to mark this thread resolved.