[Hardik Bhatt]

hi to all,
i am doing a project in that i have one search page through which i can search the specific data which is in the database,it is working fine.But i want that i can sort the search result datewise,name wise.so i have to place one sort bar on header of every field by clicking on that bar i can sort it ascending or descending.it is something same as we can sort our mails in outlook express by data,by name etc..so if anyone can help me out i'm very much pleased.
thanks

use the order by keyword in your sql statement


for example

Code:

dim sort
sort=request.querystring("sort")
if len(sort) <> 0 then
 sort =" order by " sort
end if

then in your sql add at the end & sort

make the column headings the links ?sort=fieldname

[ark2]

Hi,

You need a javascript solution: http://www.hotscripts.com/search/1651773.html

there are others out there, I've never used this particular one, but I visited one of their script users site and it seems to work fine.

ark2