sorting db entries by hour

[lala]

Hello,

I have a table that displays query results and sorts by the user's preference. The time field is currently a 12-hour format. I would like the results to sort chronologically. How do I do this? I can change the field to a 24-hour format, but then how do I format the time to display in the 12-hour format?

And do I put the formatting code in the query section or in the table section? This is the query:

elseif($schedule=='time') {$query = "SELECT * FROM classes ORDER BY '$schedule'";}

and this is the relevant part of the table that will display the results:

while ($row = mysql_fetch_row($result))
{
?>
<tr>
<td align="left">
<?=$row[0]?>
</td>

I would appreciate any help anyone can give.

Thanks,
Lisa

[notaloser]

i am guessing your $row[0] is the field that contains your hour-stamp. turn your system into a 24 hour system and do this.

$hour = $row[0];
if($hour <= 12) {
$ampm = "A.M.";
}elseif($hour > 12) {
$ampm = "P.M.";
$hour = ($hour - 12);
}

echo "The Hour is: ".$hour." ".$ampm;

**EDIT i just reread your post and my post probably didnt do anything to help you out. give an example of the timestamp you used and ill work from there