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 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. 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? Link to comment https://forums.phpfreaks.com/topic/164351-arranging-mysql-data/#findComment-867487 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.