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
Expand|Select|Wrap|Line Numbers
- $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);
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.