im new to php/mysql, help me anyone

JACK23

i need to join two different server and compare their tables. and find match email in both server tables. One table name is recover_unsub1 in recover(databse) and other table name is popular_screamer_archive in popular (databse) both table in different server.

<?php

$master = mysql_connect("master_host","10.0.3.37","...");
$slave = mysql_connect("slave_host","10.0.3.24","...");

if(mysql_select_db("recover",$master) && mysql_select_db("popular",$slave)) {
    // stuff
} else {
    echo mysql_error();
}
//Both Selected
$sql = mysql_query("SELECT * FROM recover_unsub1",$master);
$rows = array();
while($row = mysql_fetch_assoc($sql))
{

$slave_sql = mysql_query("SELECT * FROM popular_screamer_archive1 WHERE email = " . $row['email'],$slave);
while($sub_row = mysql_fetch_assoc($slave_sql))
{
$row = array_combine($sub_row,$row);
}
$rows[] = $row;
}
}
?>

Error# code not doing anything

planetsim

How is this script meant to run, is it web server or console ?

There are some coding issues.

1) I don't do much PHP these days (haven't for a few years) however I'm fairly sure PDO is what you want to use. the mysql_ should be or are about to be deprecated.

$slave_sql = mysql_query("SELECT * FROM popular_screamer_archive1 WHERE email = " . $row['email'],$slave);

Is wrong, email should be a string so at the very least (ignoring security issues, take a look into SQL Injections). Should be minimum this

$slave_sql = mysql_query("SELECT * FROM popular_screamer_archive1 WHERE email = '" . $row['email'] . "'",$slave);

Besides those simple things, its not quite clear on what you are actually wanting to do. You need to give us more information

Are you trying to create a 3rd table based on this data ?
What is the schema for the 2 tables ?
Do we really need to have all the fields returned from both tables ?
Are you wanting to output the data ?
Is there a reason every record in both tables will be stored in memory ? This is very inefficient, especially if the tables are quite large.

Weedpacket

planetsim wrote:
the mysql_ should be or are about to be deprecated.

You are out of the loop 🙂; the extension has been deprecated for over a year. New applications shouldn't use it, and existing applications should be rewritten to use one of the alternatives. (See the thread stuck at the top of the database forum for details).