sukanya.paul Posted July 1, 2009 Share Posted July 1, 2009 hi i have a table which has a field called month whose values are January,February,March etc in no particular order i am selecting all daya from this table and the month values are in the following order: January November December February March April May June July August September October i want it to be displayed in the proper order January February March .. .. .. December Can some1 please help me with this. Thanks in advance Suk Quote Link to comment https://forums.phpfreaks.com/topic/164351-arranging-mysql-data/ Share on other sites More sharing options...
Ken2k7 Posted July 1, 2009 Share Posted July 1, 2009 I would say to add a new column for the number representation of the month and use SQL ORDER BY to order them. Quote Link to comment https://forums.phpfreaks.com/topic/164351-arranging-mysql-data/#findComment-866982 Share on other sites More sharing options...
fenway Posted July 2, 2009 Share Posted July 2, 2009 Wait, why are you storing month names? Quote Link to comment https://forums.phpfreaks.com/topic/164351-arranging-mysql-data/#findComment-867487 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.