Adding sort on a table

[caedas]

How can I make a table sortable when clicking on the name of the column? I would also like it to be highlighted in like gray if possible, but have no idea how to do it.

Any help would be GREATLY appreciated! Thanks!

[laserlight]

Provide a link with a name/value pair in the query string, where the name is say, orderby and the value is say, the column name. Highlighting in gray is a matter of CSS style, not PHP.

In the processing code, check if $GET['orderby'] is set and has a valid value (i.e., a valid column name, perhaps by checking with a predefined array). Then construct the query with ORDER BY $GET['orderby'].