rikemsen

This plugin allows you to display the content of MySql tables into sortable html tables thanks to the DataTable jQuery Plugin.
You don’t need any configuration and once installed, it is ready to use.
Simply add the shortcode <code>[dbtable]</code> into an article or a page and you will have a nice and clean table.
<h3>Examples:</h3>
All parameters that contain more than one value have to be separated by commas without spaces.
Minimum needed : <code>[dbtable from=MysqlTableName]</code>
<ul>
<li><code>select=field1,field2,field3</code> will display all rows of the table and only specified fields</li>
<li><code>except=field1,field2,field3</code> will display all rows of the table except specified fields</li>
<li><code>cssClass=class1,class2</code> will add class1 and class2 to the class attribut of the table</li>
<li><code>comments=true|(false)</code> true will use comments specified in each field of the MySql table as datatable column names. If true and if a comment is missing, the plugin fallback on field name only for the one missing, not for the entire table.</li>
<li><code>pagination=true|(false)</code> will show/hide the bottom pagination links. If false, make sure you have the limit parameter large enough to display all your datas</li>
<li><code>limit=25</code> Display 25 rows by default.</li>
</ul>

DbTable to DataTable

Farhan Noor

Table Sorter turns standard HTML table (with THEAD and TBODY tags) into a sortable table without page refresh. It works on every table, whether it is coded in the wordpress template(theme) file or generated from the wordpress editor. This plugin is very handy for theme developers. It has many useful features including :
<ol>
<li>Multi-column sorting.</li>
<li>Disable sorting from particular column(s).</li>
<li>Sort multiple columns simultaneously.</li>
<li>Cross-browser support</li>
</ol>
For complete documentation and demo, please visit <a href="http://wpreloaded.com/table-sorter" rel="nofollow ugc">WP Table Sorter</a> plugin support page.
NOTE This plugin works at code level and provides only one opiton under Settings section in WordPress admin panel.
Happy coding!

Table Sorter

This plugin is excellent and saved me a ton of work trying to make a sortable column. Thank you!

Perfect


Doesn't work for dynamically updated tables (using Javascript).  Will duplicate rows.  



It also has no way to keep certain rows (like a total at the end old the table) from being sorted.



There is zero support if it doesn't work for you, I have a table column that won't sort at all, who knows why?


GENERALLY works well for STATIC tables

No more old static tables, make your HTML tables sortable.

DbTable to DataTable vs Table Sorter