Plugin: Select Entries (formerly External Entries)

The Select Entries (formerly External Entries) plugin displays the contents of any table either within your ExpressionEngine MySQL database or any other MySQL database to which you have access.

Among the parameters are “orderby”, “sort” and “limit”, and you can search by any column. The variables include “count” and “total_results”.

One possible use is ecommerce, such as when the product catalog is not in EE but in a MySQL-based ecommerce package; the plugin makes it easy to display those products within EE templates.

For more information, see the docs.

Together with the Update Entries, Insert Entries and Delete Entries plugins, it’s an easy way to integrate EE with other MySQL-based systems. And if you need the functionality of all four plugins, they’re combined in the External Entries plugin.

The plugin costs $10 per EE installation. It’s free to download (requires registration at Engaging.net) and try before you buy.

Update: Now compatible with both EE v1.x and v2.x.