Am having a website where i need to retrieve record from the database. once the page loads the record will be displayed according to the ID (the primary key) descending order, but if the visitor select DATE from the jump menu drop-down, the record should be sorted by the date, if the visitor select NEW TO OLD from the jump menu drop-down the record should be sorted from the latest to the old, if the visitor select PRICE from the jump menu drop-down, the record should be sorted by the price, etc pls how do i do this?
I think you need to use json for this or you can search many other script which will allow you to do this. http://www.google.co.in/search?q=jquery+sorting,+paging+,+filtering+table