Linking Tables

[nathan organ]

Hi, i have two databases set up, one is called test and contains phpbb2 data from my forums. the other is called chat and contains data for voodoo chat.

What i would like to do is link or synchronise the tables that contain user data.

There is one in test called phpbb_users, i have imported this to the chat database for testing purposes.

there are around 4 fields that i want to link which are:

DB from: Table From: DB to: Table To:
test phpbb2_users chat voc_users

Fields to match:

test: chat:
user_id id
user_name nick
user_sig user_info
user_lastvisit last_visit
user_email registration_email


Any help would be VERY much appreciated.