insert data into two different host

[jd57]

Hi

I would like to know if there is a way to insert data into two different host with the same fields and table, the first one is the localhost, and the other a remote host, can you please tell me if that is possible and if so how.
Thanks JD

$connection = mysql_connect('localhost','xxxx_xxx','xxxx') or die ("Couldn't connect to server."); 
$db = mysql_select_db('ixxx_xx', $connection) or die ("Couldn't select database.");

$query="insert into ihsreg (SubmitEmail,Bloom_Name,Pod_Name,

[bpat1434]

Connect to both, and in the mysql_query() call, define which connection gets which query:

$conn1 = mysql_connect('localhost', 'username', 'password');
mysql_select_db('database', $conn1);

$conn2 = mysql_connect('otherserver', 'username', 'password');
mysql_select_db('database', $conn2);

$query = "INSERT INTO ihsreg (SubmitEmail, Bloom_Name, Pod_Name) VALUES ('[e-mail]', 'Bloomer', 'Podder')";

$res1 = mysql_query($query, $conn1);
$res2 = mysql_query($query, $conn2);

[jd57]

Hi
Sorry, I'm a newbie, when you say otherhost, do you mean the host address or host username?

[bpat1434]

address....

[richie]

Working with a database on a remote host may be a problem if the user is not allowed to connect remotely. Most db users are configured for localhost connection only.

You define "who can connect" and "from where" via GRANT command.

[jd57]

thank you both for your help, although I'm not able to access the remote host, I've learned how to insert data in two different databases