Multiple sites login to MySQL DB

[Rodders]

Hi

I have an idea to build a MySQL DB and host it on the web with a custom PHP application on top of it.

Then I want to build sites for client which utilises this entity of the DB, ie not copy it for each client. I'd like each client to be able to see the data that the others have entered, and for Joe Public to see it all too through another website.

My ideal scenario is that each client's site will have a <DIV> with the content coming from the central core site. So, possibly a generic PHP script that connects to the DB and retrieves the data. Or, would it be possible for a 'foreign' website to connect to a MySQL DB on another site/server ??

Cheers

Rich

[devinemke]

as long as you have the porper access rights you can connect to a mySQL server via [man]mysql_connect[/man]. be advised that some commercial hosting companies do not allow remote connections to there database servers.