Re: Access a database on another domain

On Sun, Aug 2, 2009 at 10:15 PM, Chris<dmagick@gmail.com> wrote: > 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/ > > > -- > PHP Database Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > You should be able to access this by creating a shared mysql account and setting the different domains to use it. -- Bastien Cat, the other other white meat