Why doesn't this script function?

[RON_ron]

Why doesn't this code update two mysql databases (on two servers)? What am I doing wrong?

 

//SERVER 1 
$link = mysql_connect("localhost","usern1","pw1"); 
mysql_select_db("db_one1"); 

//SERVER 2 
$link = mysql_connect("xxx.xxx.xx.xxx","usern2","pw2"); 
mysql_select_db("db_one2"); 

$query = "INSERT INTO db1(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query); 

$query = "INSERT INTO db2(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query); 

$sentOk = "The data has been added to the database."; 
echo "sentOk=" . $sentOk; 

[trq]

Your saving both connections within the one variable called $link. Hence, the second connection overrides the first.

 

You then fail to pass any specific connection to mysql_query.

[Rohlan]

Your code should look more like this: (didn't proof read it)

 

//SERVER 1 
$link = mysql_connect("localhost","usern1","pw1"); 
mysql_select_db("db_one1"); 

$query = "INSERT INTO db1(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query); 

//SERVER 2 
$link = mysql_connect("xxx.xxx.xx.xxx","usern2","pw2"); 
mysql_select_db("db_one2"); 

$query = "INSERT INTO db2(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query); 

$sentOk = "The data has been added to the database."; 
echo "sentOk=" . $sentOk; 

 

Because you rewrite the $link variable on the second connection...

This way you connect to the first db then send the info... then connect to second db and send info.

[PradeepKr]

check correct syntax

http://php.net/manual/en/function.mysql-query.php and http://www.php.net/manual/en/function.mysql-select-db.php

 

 

//SERVER 1 
$link = mysql_connect("localhost","usern1","pw1"); 
mysql_select_db("db_one1", $link); 

$query = "INSERT INTO db1(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query, $link);

if(mysql_num_rows($result) == 0) {
$sentOk = "The data has been added to the database."; 
echo "sentOk=" . $sentOk;
}


//SERVER 2 
$link = mysql_connect("xxx.xxx.xx.xxx","usern2","pw2"); 
mysql_select_db("db_one2", $link); 

$query = "INSERT INTO db2(subject, search, News, img) VALUES('$hsubject','$key','$news','$img')"; 
$result = mysql_query($query, $link); 

if(mysql_num_rows($result) == 0) {
$sentOk = "The data has been added to the database."; 
echo "sentOk=" . $sentOk;
}

[RON_ron]

Thanks mates!  Before trying these, Just one more thing..... Do I have to give permission to update an MYSQL?

 

E.g. If I'm on server 1 and using this script to update the mysql on server 1 and server 2.

[trq]

Do I have to give permission to update an MYSQL?

 

Of course, as always,  you need permissions to execute the queries. If its a remote server, you'll need permissions just to connect to it.