Re: Help with mysql data sorting using php
| From: | nagendra prasad | Date: | Mon, 17 May 2010 07:17:54 +0000 |
| Subject: | Re: Help with mysql data sorting using php | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-47168@lists.php.net to get a copy of this message | ||
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@gmail.com>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@gmail.com> 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.
>
>