Problem with applying Sql order by to html table
Hi to all,
I am having a web page,I want to apply sql order by command to html table.
TestCase_asc=select * from mytable order by testcase asc;
TestCase_desc=select * from my tableorder by testcase desc;
user_asc=select * from mytable order by user asc;
user_desc=select * from my tableorder by user desc;
My html table:
When user clicks on fields,Records should sort by calling above sql commands.
Any one please give me the code for this.
Thanks in advance