Re: Access a database on another domain

Neil Jackson wrote:

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hi, I host a number of running clubs websites. They are all hosted on different domains on a hosting service. They all share a common database table of fixtures. At present I have copied the database table to each domain but this time consuming. I want to have a central database with the individual clubs accessing the table from their domains At present I do it like this $result = @mysql_pconnect("localhost", "username", "password"); $query = "SELECT * FROM fixtures ORDER BY event_name";

I haven't seen a question here, but I assume you don't know where to start. Enable remote access to mysql: http://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html Then connect to it: mysql_connect('server.name', 'username', 'password'); -- Postgresql & php tutorials http://www.designmagick.com/