how to fetch data from remote server

[bhavaniReddy]

I have one table t1 on database d1 of the server s1 and now another table t2 is in d2 of the server s2.Now i want some data of the table t1 and its related data from t2 table as resultant data.how can i make it possible and fetch data
can any one explan me step by step plz
i am worried i am trying from 1 week help me plz
i am new to php plz help me frdz

[computerfox]

There's two options, you can build a local API using PHP on s1 which would be the safest or you can set your mysql to allow connections from x host or x IP. My personal choice would be the API.