local to remote database problem

[tonvlad88]

---

guys,,

do u have any idea on how to collect local database data into an array and paste it into the remote database. here's my sample code:

-------------------------------------------------------------------------------------------------
//this is the local database

$dbhost = "localhost";
$dbuser = "root";
$dbpass = "";
$dbname= "mydb";

$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die ("Error connecting to database of the localhost...");
mysql_select_db($dbname);

$query = mysql_query("SELECT * FROM dbuser");

$row = mysql_fetch_array($query);

$name = $row['lname'];

echo $name;

//this is the remote database
$dbhost1 = "mysql";
$dbuser1 = "myuser";
$dbpass1 = "mypass";
$dbname1 = "mydblocal";

$conn = mysql_connect($dbhost1, $dbuser1, $dbpass1) or die ("Error connecting to database of the remote...");
mysql_select_db($dbname1);

-------------------------------------------------------------------------------------------------

is it possible pls.. help.. tanx...

[Klave]

use another variable for the second connection kay mawala ang reference sa first connection.

first query from the local connection...

you then either...

extract the data from the entire resultset or extract the data one row at a time
then transfer to the other db by embedding the data
either into a batch insert or a simple insert.