passing data bw 2 different sites

[heathmont]

lets say i have a site built using php / mysql and can display the results to certain queries no problems on site a.

i then create site b (different domain and server). site b is someone else's site but within one directory they want to run the same queries as my site a and then serve the results within site b.

administration of the database will still take place on the back end of site a (and the site a front will be updated as per normal), I just want to have a syncronised version of a certain section of my site a - being displayed on site b.

is this possible?

would it then matter if site b was written using cold fusion (like is it possible to mix and match different programming languages (or would it be better to have a subdomain on site b (redirect.siteb.com) point to my dns info for site a?

looking forward to your replies!

thanks tim

[jatar_k]

well if you are using php and take a look at mysql_connect

[ca.php.net...]

resource mysql_connect ([string server[, string username[, string password[, bool new_link[, int client_flags]]]]])

The server parameter can also include a port number. eg. "hostname:port" or a path to a local socket eg. ":/path/to/socket" for the localhost.

so it is therefore possible to connect to a remote host for your db.

is it possible to mix and match different programming languages

I don't see a problem with because it is just connecting to mysql which doesn't have any dependancy oon the language used. You will have to rewrite the code you use into that language though.