Accessing multiple databases


Hi all, in a bit of a pickle, hope you can help.

Assume i have 1 database with a users and a comments table, the, followign sql is fine,

SELECT u.name, c.comment FROM user u, comment c WHERE c.userid = u.userid;

Now, how could this be achived if the user table was held in a different database How would it work

Help

Taz
Posted On: Wednesday 24th of October 2012 12:30:20 AM Total Views:  350
View Complete with Replies

RELATED TOPICS OF PHP PROGRAMMING LANGUAGE