I need a component that will merge content from the localhost database table(s) into a content layout as defined in another table. I would code numerous layout pages with some type of plug-in code to pull in the appropriate fields as needed.
The challenge I am facing is that I have roughly 1,000 product families and >7,000 individual part numbers in a Joomla 1.5 website (could migrate to 1.6 if needed). The challenge is that I am continually asked to make adjustments to the content layout, which causes me to edit thousands of pages.
The existing site is heavily SEM'd, so I can not change existing urls, so I will need absolute control over the url address, which could be a field in one of the tables I pull from or controlled by SH404SEF. Since these urls would not change, creating them once would not be an issue. I plan to do most, if not all, of the data entry with the PHP/MyAdmin tool, so I need minimal interface on the back end and none on the front end.