in reply to Accesing a database from different sites

but he wants some users in "site1" to be able to access "site2" with all the profile information, etc.

Well this is the big question. Does he want all or some?

If you want all the user info then yes accessing a remote database would be your answer.

To do this just create 2 Database handles:

my $dbh = DBI->connect('DBI:mysql:database=dbname;host=localhost','use +r','pass'); my $dbh_user DBI->connect('DBI:mysql:database=userdb;host=remote','use +r','pass');

Even better use Class::DBI. You'll be able to hide all the ugliness of having 2 separate databases. Just create 2 unique DBI classes to inherit from.

grep
Mynd you, mønk bites Kan be pretti nasti...