need help with php/mysql, anyone?
Posted: Fri Aug 01, 2014 9:38 am
I'm trying to compare two different server tables and compare the match email output. please tell me whats wrong in my code.
Code: Select all
<?php
$master = mysql_connect("master_host","10.0.3.37","gramercy");
$slave = mysql_connect("slave_host","10.0.3.24","gramercy");
if(mysql_select_db("recover",$master) && mysql_select_db("popular",$slave))
{
//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;
}
}
else {
print "Database NOT Found ";
}
?>