Page 1 of 1

arranging mysql data

Posted: Wed Jul 01, 2009 3:09 am
by sukanya.paul
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

Re: arranging mysql data

Posted: Wed Jul 01, 2009 8:18 am
by Salaria
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.