sudhakararaog

i am building a registration page where a user register for a username. i am able to insert this into mysql. the situation is every time data is inserted into example table1 in mysql in database1 for example at the same time i would like to extract the username, password and email from table1 based on the last inserted row and insert these values into another table ex table2 in a different database called database2.

the issue i am having is with the select query as it is not returning values from table1 for me to insert those values into table2 in database2.

NOTE = the hostname, user name, password are the same for both the tables and databases and are physically in 1 server machine itself.

presently my code is

$conn = mysql_connect($hostname, $user, $dbpassword);

if(!$conn)
{

}
else
{
mysql_select_db($database, $conn);
$insertqueryresult = mysql_query($insertqueryfortable1);
$lastid = mysql_insert_id();

$selectqueryoftable1 = "Select username, password, email from table1 where slno = '$lastid'";
slno is an autoincrement and primary key which is like a serial number

$selectunempsq = mysql_query($selectqueryoftable1);

while($rowunemps = mysql_fetch_assoc($selectunempsq))
{
$unis = $rowunemps['username'];
$psis = $rowunemps['password'];
$emis = $rowunemps['email'];
}

$insertqueryfortable2 = "Insert into table2(username, password, email) VALUES ('$unis', '$psis', '$emis')";

$unpsemresult = mysql_query($insertqueryfortable2);

the values in the 3 variables $unis, $psis, $emis are blank.

i have tried
a) while($rowunemps = mysql_fetch_array($selectunempsq))
b) creating the table2 in database1 itself to see if it works
but both these methods is not working

data is being inserted into table1 but i am not able to read the values stored in table1 and then insert into table2. i have used echoing the values of the 3 variables $unis, $psis, $emis however the values are blank. with the insertquery for table2 everytime the insert query is executed a new row is created but there are no values for the 3 fileds username, password, email in table2

initially i had $conn = mysql_connect($hostname, $user, $dbpassword); 2 times as the tables were in different database now i have only 1 mysql_connect

please advice how to fix this ideally both tables sitting in different databases.

thanks.

CloudedVision

You use mysql_select_db to select which database is your default. Since table2 isn't in the selected database, mysql can't find it. If you use "database2.table2" instead of "table2" should make mysql query the right database.

__________________
Theron Luhn