0 Replies Latest reply on Sep 4, 2008 11:50 PM by fypstudent

    datagrid sort by days (mon, tue, wed)

    fypstudent
      Hi i displayed a list of the lecture's class schedule on the datagrid as shown,
      http://i192.photobucket.com/albums/z63/nellehs/Picture2.png

      as you can see, how do i actually sort the days in ascending order like, monday, tuesday, wednesday...?
      I would also need to sort the time as well that corresponds to it's group day like, (monday) group sort time (09:00), (10:00), (tuesday) group sort time (14:00), (16:00). So how do i actually sort the days accordingly? there are the coding...

      the php coding that retrieve the data
      $sql = "SELECT * FROM timetable WHERE staffid = '$staffid'";

      <mx:DataGrid x="10" y="155" dataProvider="{timetable}" width="1004" height="383" id="tableCol">

      <mx:columns>
      <mx:DataGridColumn headerText="Day" dataField="day" width="50"/>
      <mx:DataGridColumn headerText="Start" dataField="start" width="50"/>
      <mx:DataGridColumn headerText="End" dataField="end" width="50"/>
      <mx:DataGridColumn headerText="Subject" dataField"mod"/>
      <mx:DataGridColumn headerText="Room" dataField="room"/>
      </mx:columns>
      </mx:DataGrid>