Taking data from database to another site

[steveinspain]

Hi, I have a real estate client who wants to sell advertising on his site to other estate agents.
When they sign up with him he wants to show their logo and name of company then a link to view all their properties.

Also the properties will be included in his sites main search facility.

To do this I would imagine that his site will have to connect to the agents database in some way.

I have no idea how I can achieve this.

Does anyone have any ideas?

Thanks

[omoutop]

best option i can think is for xml data exchange
you create a page where you ask for an xml file from the target site.
you get your data in this xml and you upload/update them to your db

use either file_get_contents() or curl() (personally i prefer curl)

[steveinspain]

I will look into this as I am a bit out of my depth here.

Thanks for your reply.

[coopster]

Maybe, maybe not. Somehow you need to merge the data from multiple databases, correct? If you are sending your data to an MLS and if they are doing the same, you are likely using a very similar format and you could use that to merge their properties with yours within your system. You could either use the same database tables or run a parallel table to implement their properties.

I think you will need to brainstorm a few details first and then the plan will start to form. Get it all laid out and start there. Is it going to be simple programming? Not likely, but it certainly shouldn't be something beyond what you could accomplish if you so desired.

And a very belated welcome to WebmasterWorld, steveinspain.