View Single Post
  #1 (permalink)  
Old 02-02-2008, 07:17 PM
sireesha264 sireesha264 is offline
Member
 
Join Date: Jan 2008
Posts: 4
sireesha264 is on a distinguished road
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
Reply With Quote
Sponsored Links