I have a CGI file written in Perl. I query data from a sqlserver using DBI and display it on the html page from a single table. The web page displays the data in six columns such as firstname, lastname, DOB etc. When the data loads, the server side query is ordered by just the DOB. However after it is displayed on the page, when the users click on the column headers such as firstname or lastname, I want to sort the values by those columns. Not sure whether it could be done at the client side using javascript or has to be done at the server side. Any help is greatly appreciated. I saw similar question already in the stackoverflow database, but not much useful.
Thanks