Problem with applying Sql order by to html table

[sireesha264]

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

[jelly]

Do you already have code to create the table, if so post it and then people can start to explain how you would change what you have

[sireesha264]

My table is as follows,Pease any body give me the idea.
<table>
<tbody>
<tr>
<th>TestCase</td>
<th>User</td>

</tr>
<tr>
<td>test1</td>
<td>ANTONY</td>
</tr>
<tr>
<td>Count</td>
<td>ZXc</td>
</tr>
<tr>
<td>Compare</td>
<td>ABC</td>
</tr>
</tbody>
</table>

Thanks in advance.