I need to display product information within my Joomla website that pulls information from another MySQL db - not the Joomla DB. I think I can do this with a simple PHP page that calls the info using the Jumi addin for Joomla. Jumi will execute any PHP code within Joomla.
1. The database will hold basic product info - essentially 6 fields of data
2. I need an administrator page to add, edit, and remove products from the database - this must be password protected and does not need to be within Joomla (but can be if you can make it more user friendly that way).
3. I need to pull the product listings from the db and display them on the webpage - in row format, one after another.
3.1 I need to be able to filter these results based on product size and product type
3.2 I need to have a graphic link that will allow the user to produce a printable version of the output.
Web server is typical LAMP stack.