mysql Database auto update

[Hustle]

I have a Mysql Data base for my website. I am wanting to create an automatice data feed from other websites on to mine. but I don't know where to start. It is a property portal sp I need it to update other estate agents properties to it.

[beso]

One way is to generate an XML export file from the other databases. This file contains all the data and field names in a text format. MS Access will generate XML output very easily but theoretically a report can be written to generate XML from any database.

This data is then run through an XSL filter which generates a file of SQL queries containing the data that will add the information to your database.

[beso]

Another way is to connect to the databases through ODBC. This allows the tables on one database to appear inside another. Then use queries to update the tables in each database.

[Hustle]

Thank you!

Will this update automatically with out any manual input from the other estate agent or myself?

Thanks again.

[beso]

With the XML the other sites will have to export and you will have to run the importing routines.

With the ODBC you will have to run the queries in your database.

It is hard to work out what you need without knowing a lot more about what is available from the other sites. You will need their cooperation to set up a system.