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

2010-05-17 Thread kesavan trichy rengarajan
take a look at this: http://datatables.net/examples/data_sources/server_side.html On Mon, May 17, 2010 at 5:30 PM, nagendra prasad wrote: > Hi Artur, > > I am a beginner to this stuff. So, If you or anyone can give me some > example > codes or may be some links for my reference that would be a gr

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

2010-05-17 Thread nagendra prasad
Hi Artur, I am a beginner to this stuff. So, If you or anyone can give me some example codes or may be some links for my reference that would be a great help. Best, Guru. On Mon, May 17, 2010 at 12:57 PM, Artur Ejsmont wrote: > Hehe. Then a method: ) just make a query builder method like 'findS

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

2010-05-17 Thread Artur Ejsmont
Hehe. Then a method: ) just make a query builder method like 'findSongs' with all the params ( optional or mandatory ) like page, limit, sortby, filters etc. then inside build SQL based on args. Just be careful - SQL injection is your enemy here. From app pass all the args from get/ post and that'

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

2010-05-17 Thread nagendra prasad
DB is like more then 500MB and it will grow day by day :) On Mon, May 17, 2010 at 12:46 PM, Artur Ejsmont wrote: > If the DB is very small use tablesorter plugin of jquery. Otherwise > custumizable query method. > > On 17 May 2010 07:56, "nagendra prasad" wrote: > > Hi All, > > I have a datab

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

2010-05-16 Thread nagendra prasad
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