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
arranging mysql data
Moderator: General Moderators
Re: arranging mysql data
Hi,
Add an orderid field in a table or Insert values sequentially with ids and select sorted data using id.
I think this will help.
Add an orderid field in a table or Insert values sequentially with ids and select sorted data using id.
I think this will help.