On Sun, Aug 2, 2009 at 10:15 PM, Chris<dmagick@xxxxxxxxx> 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
