corkg Posted July 17, 2008 Share Posted July 17, 2008 Is it possible to run a sql query that will group all months the dates are ordered dd/mm/yyyy in the database how can I group the months together? Thanks Link to comment https://forums.phpfreaks.com/topic/115198-group-by-month/ Share on other sites More sharing options...
Xurion Posted July 17, 2008 Share Posted July 17, 2008 SELECT * FROM table GROUP BY date Link to comment https://forums.phpfreaks.com/topic/115198-group-by-month/#findComment-592353 Share on other sites More sharing options...
fenway Posted July 17, 2008 Share Posted July 17, 2008 SELECT * FROM table GROUP BY date First, you can't select * with a GROUP BY. Second, I don't even understand the question. Link to comment https://forums.phpfreaks.com/topic/115198-group-by-month/#findComment-592591 Share on other sites More sharing options...
Xurion Posted July 18, 2008 Share Posted July 18, 2008 I'm confused - I just successfully did a SELECT * with a GROUP BY :-\ Link to comment https://forums.phpfreaks.com/topic/115198-group-by-month/#findComment-593178 Share on other sites More sharing options...
fenway Posted July 23, 2008 Share Posted July 23, 2008 I'm confused - I just successfully did a SELECT * with a GROUP BY :-\ You can do it, but anything other than the group-by'ed column will be meaningless! Link to comment https://forums.phpfreaks.com/topic/115198-group-by-month/#findComment-597916 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.