DB is like more then 500MB and it will grow day by day :) On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont <ejsmont.artur@xxxxxxxxx>wrote: > If the DB is very small use tablesorter plugin of jquery. Otherwise > custumizable query method. > > On 17 May 2010 07:56, "nagendra prasad" <nagendra802000@xxxxxxxxx> wrote: > > Hi All, > > I have a database of MP3's in mysql. The database contains MP3 name, > artist, > date, size etc. I need to order the search results in both ascending and > descending order. For example if user wants to see the size of all mp3's in > ASC order he will click on size column and again if he wants to see the > MP3's in DEC order he can click on the size column. Suppose the MP3's are > arranged in ASC order and if he clicks on size column the data should > arrange in DEC order. > > Any idea how I should go about it ? > > Please help me :) > > Best, > Guru. > >
