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? Quote 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) Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.