|
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:
TestCase User
test1 ANTONY
Count ZXc
Compare ABC
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
|