In most of the project, we need to write a lot of queries to create admin backend. Especially for report generation.In old days I used phpTables. But recently I started using Flexigrid, a jQuery plugin for displaying tables. It is very simple to write code and all work in Ajax

Here is the url: http://flexigrid.info/

If you are using Codeigniter, a good library is also available to integrate Flexigrid. You can download it from here

flexigrid