php import help

[Meyer]

What am i doing wrong here?


<?php
$dbhost1 = "dedi212.jnb2.host-h.net";
$dbuser1 = "";
$dbpassword1 = "";
$db1 = "risingfs_rcjan2010";
$connection1 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
mysql_select_db($db1,$connection1);

$dbhost2 = "41.66.140.74";
$dbuser2 = "";
$dbpassword2 = "";
$db2 = "edutoy";
$connection2 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
mysql_select_db($db2,$connection2);


$mysql_query ="
INSERT INTO risingfs_rcjan2010.aa(risingfs_rcjan2010.aa.a,risi ngfs_rcjan2010.aa.b)

SELECT edutoy.products.id,edutoy.products.NAME FROM edutoy.products.products

}
?>

[d1m0]

For starters, I don't see a mysql user and password added. If you want to connect to your database, you'll have to create a mysql user and grant it privileges to access the database(s).

Of course, you may have removed these for security reasons (I wouldn't want my mysql details listed in a forum either).

Thus, if you want us to try and help you, you should tell us what exactly you want to achieve, as well as provide us with the exact error message you receive.

[Meyer]

You are correct. i do not show my logoon details.

What i want to achieve is, i have my sugar crm database on this server. but on another server different host i have a data warehouse.

I need to everynight import data from my sugar database to my data warehouse table.
I get no errors but also nothing happens. It works with apatar integration but i need this in php code.

<?php
my warehouse db
$dbhost1 = "dedi212.jnb2.host-h.net";
$dbuser1 = "";
$dbpassword1 = "";
$db1 = "risingfs_rcjan2010";
$connection1 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
mysql_select_db($db1,$connection1);

// my sugar db
$dbhost2 = "41.66.140.74";
$dbuser2 = "";
$dbpassword2 = "";
$db2 = "edutoy";
$connection2 = mysql_connect($dbhost1,$dbuser1,$dbpassword1) or die (mysql_error());
mysql_select_db($db2,$connection2);

// my query

$mysql_query ="
INSERT INTO risingfs_rcjan2010.aa(risingfs_rcjan2010.aa.a,risi ngfs_rcjan2010.aa.b)

SELECT edutoy.products.id,edutoy.products.NAME FROM edutoy.products.products

}