Multiple sort from same table

[vaavi8r]

I have a table that includes aircraft flights. I want to do the following:

1) To automatically display the flights leaving in the next hour.

2) To allow the user to select and sort ALL of the data by aircraft type OR departure point.

I have written some PHP scripts before, but cannot find how to do this after looking through all of the manuals I can find.

Can someone point me in the right direction or give me some ideas of scripting?

[LordShryku]

How's this info displayed to them? In an HTML table? How are they supposed to tell the script to sort by something different?

[vaavi8r]

Yes, it is an HTML table.

I want the flights departing in the next hour to appear on the page, but I also want the user to be able to search and display by BOTH departure point and aircraft type.

Thanks