I was woundering the same question. You want to access an sql database from a differant site. I know its possible because many people use multiple servers for one sql. I would like the source code for that also please. Is there a way to make 2 dbs with same tables but differant entries to applear on a site (lets say one db gets full so you make another one to store other usersers on but you want them both to be accessed when someone does something like searching members). Im not sure if thats possible or if anyone knows what I am talking about.
You can try the federated database, it serve as a link to another databased located else where. But this require MySQL 5.0, most common hosting server only has MySQL 4.