eevan79 Posted September 26, 2010 Share Posted September 26, 2010 How to get all years from one table? For example I have table "games" and in field "date" have: 2009-06-23 11:27:33 2009-06-24 15:27:33 2009-06-25 13:27:33 2009-06-26 10:27:33 etc... 2010-06-26 10:27:33 2010-06-26 10:27:33 ... 2008-06-26 10:27:33 2008-06-26 10:27:33 .... So I want to get 2008, 2009 and 2010 for drop down box: [DROP DOWN] -[2010] -[2009] -[2008] I know that it can be used WHERE YEAR(datetime) = 2010 or YEAR(datetime) = 2009 for every single query. But how to find this years automatically? Link to comment https://forums.phpfreaks.com/topic/214409-how-to-find-all-years-for-drop-down-box/ Share on other sites More sharing options...
PFMaBiSmAd Posted September 26, 2010 Share Posted September 26, 2010 GROUP BY YEAR(datetime) Link to comment https://forums.phpfreaks.com/topic/214409-how-to-find-all-years-for-drop-down-box/#findComment-1115784 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.