ordering output

I have a page that I put together that pulls in data for the time in individual fields - hour, minute, am/pm, month, day. I am going to alter the db to add year as well. I want to order this list by multiple criteria - first by year, then by hour, am/pm, minute. It is a page that lists shows that are running on a local cable channel. Is there a way to do what I am asking? I know that I can 'select * from table order by year asc' but don't know how to sub order the items. thanks, DF