Pagination and Best way for Optimization of data load

[eluser]boltsabre[/eluser]

seem Ajax JQuery PHP is the only viable solution

I don't really know what you mean there, you're talking about a server side language (php), a client side javascript library (jQuery) and a Ajax... do you mean to get the entire DB table and let jQuery do all the sorting on the users machine? If so be VERY careful with this, you'll crash their computer if you try to load to much data into browser memory!!!