No replies to this topic

[Howlin1]

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)?

Attached Files

•  Untitled.png   43.98K   4 downloads