We have 7 joomla website built with joomla 1.5
1 main site and 6 subsites.
We want the main website to have a news section which feeds from the the news from the subsites.
i think the best way to achieve this is to put the databases for all of the joomla websites into 1 database (each subsites data will be held in table with unique table names) then to create a script which queries the different tables.
The data has to be displayed as a by date order list. Each subsites news should not be in a seperate list, the list should hold all data from all subsites in date order
This task is to:
- migrate data from seperate databases into 1 database
- create news script which queries the 7 content tables and creates a list of news
- on click of the news title it should take the user to the relevant websites full news article
budget = 75$