Access a database on another domain

-----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"; Two of the domains are www.hillcrestvillagers.co.za and www.pmb42.co.za. Thanks for the help Neil -----BEGIN PGP SIGNATURE----- Version: GnuPG v2.0.9 (GNU/Linux) Comment: Using GnuPG with SUSE - http://enigmail.mozdev.org iEYEARECAAYFAkp2RfoACgkQGgk1S8edB3I48ACeODQFinlcJIFuaxFItREabRxt zGAAn1Vde3l6f6eVZtnv/xLQRS/YOYi4 =refm -----END PGP SIGNATURE-----