Re: [PHP-DB] Help with mysql data sorting using php

DB is like more then 500MB

and it will grow day by day :)



On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont <[email protected]>wrote:

> If the DB is very small use tablesorter plugin of jquery. Otherwise
> custumizable query method.
>
> On 17 May 2010 07:56, "nagendra prasad" <[email protected]> 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.
>
>