Hello,I am wondering is there any way to sort a list by the days of the week (i.e. it should list Monday, Tuesday, Wednesday, Thursday and Friday)?I am trying to make a kinda of timetable of free rooms in a building and list the weekdays (Monday - Friday), Floors (Ground, first and second) and then the time (9 am until 4pm, but I have that solved by using the 24 hour time).Ideally what I want is to call the free rooms table for all the days/time etc of rooms that are free, and sort that list by the day of the week and then sort that result by the floor (but keeping Monday first). What I have at the moment is:
$result= mysql_query( "SELECT * FROM free_rooms ORDER BY Day, Floor, Time ASC") or die("SELECT Error: ".mysql_error()); echo '<p>This is a list of all the rooms that are free and on what day.</p> <table border="1" width="400"> <tr align="center"> <td><b>Day</b></td> <td><b>Floor</b></td> <td><b>Room</b></td> <td><b>Time</b></td> </tr>'; while ($get_info = mysql_fetch_row($result)) { print '<tr align="center"> <td><b>' . $get_info[1] . '</b></td> <td>' . $get_info[4] . '</td> <td>' . $get_info[2] . '</td> <td>' . $get_info[3] . ':15</td> </tr>'; } print ' </table>'; mysql_close($link); ?>
(I'm assuming the get_info is a 2d array) So what I would need to do is to sort the get_info[1] array so Monday is first, Tuesday, Wednesday, Thursday and finally Friday. Then sort the floor (get_info[4]) by Ground, First and Second, while keeping Monday first.On the order by clause I did try putting in ('Monday') for the day, but it only brought one or two of the Mondays to the top. I don't know enough about php (I'm a novice really) to do what I would like to do.Is there anyway that what I want done, can be done (wholly or partially)?
