This should be simple.. DB1 data to DB2 data

[remdotc]

Anyone see a problem with this?

Ia m trying to take username and password from one database and pass the same data to another database (phpwebchat) so the users username and password are inserted into to phpwebchat database everytime they call chat.php

mysql_close();

mysql_connect ($forum_server,$forum_db_user,$forum_db_pass) or die(mysql_error());

#$avatar="images/blank.gif";
			$website="http://www.#####.com";
			$firstname="paid";
			$lastname="member";
			$email="members@#####.com";
			$showmail="0";
			$perms="user";
			$latin1="1";
			$country="perfect";
			$gender="0";
			$reg_time="1036203998";
			$rooms="";






mysql_db_query($forum_database, "insert into c_reg_users (username, latin1, password, firstname, lastname, country, website, email, showmail, perms, gender)

               values ('$username', '$latin1', '$password', '$firstname', '$lastname', '$country', '$website', '$email', '$showmail', '$perms', '$rooms', '$gender')");

mysql_close();

mysql_connect($server, $db_user, $db_pass);

?>

[barand]

mysql_db_query($forum_database, "insert into c_reg_users (username, latin1, password, firstname, lastname, country, website, email, showmail, perms, gender)

values ('$username', '$latin1', '$password', '$firstname', '$lastname', '$country', '$website', '$email', '$showmail', '$perms', '$rooms', '$gender')");

You haven't specified where to put $rooms