Thanks for the replies, really appreciate it.
@Guido2004 another database that will have many tables.
once the user has been logged in, you should be able to just connect to the second database in the same way you connected to the 1st database, to check their username/password, but this time using the paramaters of the 2nd database.
OK so would I need to use a field from the user db to associate the data in the second db. Therefore I would have to create a field in the second db that appears in the first db to make the link.
Here is my attempt in psuedo code
$mysql_result=mysql_query("SELECT * FROM dbname and tablename1, tablename2,tablenameN WHERE id="value-from-first-db,showfields;
I do not know whether that helps, I am trying to learn this stuff and my head hurts.