Recommendation for a Dynamic Table Plugin

Question

Can anyone recommend plugin that I can use to add a table to a page? I've seen ones that use static data-- you hardcode the figures in the table. I want to pull the data from a custom db table and put it in a table.

I looked at WP Table Reloaded, but I'm not sure whether, it's possible to use it with dynamic data.

Any suggestions?

Thank you.

Answer 1

Set up a custom page template and in the content of the template use WPDB to query your table.

Example to get a row:

$mylink = $wpdb->get_row("SELECT * FROM $wpdb->links WHERE link_id = 10");

Answer 2

The closest thing to what you are looking for would be ProjectManager http://wordpress.org/extend/plugins/projectmanager/ without creating the database tables manually.