2 approaches I can think
1) add a field in your table called "newmonth" etc.
I think add a field with date type or varchar, and run the sql
update yourtable set newmonth="01" where youroldmonth="January"
update yourtable set newmonth="02" where youroldmonth="February"
etc.
And then sort by the newmonth
2) don't change the database,
a) first, select the records from your table and save them in arrays
such as name_array[], month_array[], etc.
b) second, create a newmonth_array[] based on walk through the month_array[]
such as
for ($index=0; $index<count($month_array); $index++)
{
if ($month_array[$index]=="January")
$newmonth_array[$index]="01";
elseif ($month_array[$index]=="February")
$newmonth_array[$index]="02";
...
}
c) call the array_multisort () sort by the $newmonth_array
array_multisort($newmonth_array, $name_array, $month_array ...)
d) for loop to display the sorted arraies.
