By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,009 Members | 1,643 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,009 IT Pros & Developers. It's quick & easy.

sql+php help

P: n/a
hy

I have two mysql servers. One is on my local comp (localhost) and the other
is something.com
Creating simple php script to do this...

----------------------------------------------------------------------
$db1 = mysql_connect("something.com", "username", "pass") or die("Could not
connect.");
if(!$db1)
die("no db");
if(!mysql_select_db("smjestaj",$db1)) die("No database selected.");
$db2 = mysql_connect("localhost", "username", "pass") or die("Could not
connect.");
if(!$db2)
die("no db");
if(!mysql_select_db("smjestaj",$db2)) die("No database selected.");

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

i nead to execute this query on my local comp's web server.

update table2
set zauzetost = t1.zauzetost
from table2 t2, table1 t1
where t2.id = t1.id
table2 is on remote server, table1 is on local comp.
How to do this? I'm poor coder, so...

tnx in advance on your brain cells.
Dejan

Jul 10 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a
Dejan wrote:
hy

I have two mysql servers. One is on my local comp (localhost) and the other
is something.com
Creating simple php script to do this...

----------------------------------------------------------------------
$db1 = mysql_connect("something.com", "username", "pass") or die("Could not
connect.");
if(!$db1)
die("no db");
if(!mysql_select_db("smjestaj",$db1)) die("No database selected.");
$db2 = mysql_connect("localhost", "username", "pass") or die("Could not
connect.");
if(!$db2)
die("no db");
if(!mysql_select_db("smjestaj",$db2)) die("No database selected.");

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

i nead to execute this query on my local comp's web server.

update table2
set zauzetost = t1.zauzetost
from table2 t2, table1 t1
where t2.id = t1.id
table2 is on remote server, table1 is on local comp.
How to do this? I'm poor coder, so...
You query table1 and table2 and store those in two multi dimensional arrays,
then you create your third multi dimensional array into where you store the
joint rows of table1 and table2.
//Aho
Jul 10 '06 #2

P: n/a
Yeah right. I have tried playing with multidimensional arrays, buth with my
knowlege :))

Why cann't i use this with what sql query?

You query table1 and table2 and store those in two multi dimensional
arrays,
then you create your third multi dimensional array into where you store
the
joint rows of table1 and table2.
//Aho

Jul 11 '06 #3

P: n/a
Dejan wrote:
Yeah right. I have tried playing with multidimensional arrays, buth with my
knowlege :))

Why cann't i use this with what sql query?
>>You query table1 and table2 and store those in two multi dimensional

arrays,
>>then you create your third multi dimensional array into where you store

the
>>joint rows of table1 and table2.
//Aho


Unless something has changed, you can't query across databases on
different servers.

Also, if you ask a question in a PHP group expect to get a PHP response.
If you want a MySQL response, try a MySQL group such as
comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================
Jul 11 '06 #4

P: n/a
Mel
On 2006-07-11 21:58:26 +1000, Jerry Stuckle <js*******@attglobal.netsaid:
Dejan wrote:
>Yeah right. I have tried playing with multidimensional arrays, buth with my
knowlege :))

Why cann't i use this with what sql query?
>>You query table1 and table2 and store those in two multi dimensional

arrays,
>>then you create your third multi dimensional array into where you store

the
>>joint rows of table1 and table2.
//Aho



Unless something has changed, you can't query across databases on
different servers.

Also, if you ask a question in a PHP group expect to get a PHP
response. If you want a MySQL response, try a MySQL group such as
comp.databases.mysql.
I don't know if it's valid SQL (or just T-SQL), but:
MSSQL supports connecting to multiple servers in a single statement. Ex:
select tbl1.*, tbl2.*
from localhost.mylocaldatabase.dbo.table_one as tbl1
join otherhost.myremotedatabase.dbowner.table_two as tbl2 on tbl1.id = tbl2.fk

Jul 11 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.