How to make Certain Pages Point to Common Database?

Quizboy

Hi, I've got a series of duplicate sites running, not 100% duplicates but similar and they're all part of the same network of sites.

The thing is, I need certain pages of the copied sites to pull their information from the main site. But not the entire database should be pulled from the main site. To clarify:

http://www.milliondollarhomepageformilliondollarhomepages.com

is the main site. and

http://www.milliondollarhomepageforpeople.com is one of the satellite sites. This site (and all the others) needs to pull its FAQ, and blog information from the database of my main feeder site.

The problem: Right now I've tried having the faq.php page include a specific to this purpose configure_millions.php file from the original site using a full length url like so:

include("http://www.milliondollar.....configure_millions.php");

this configure file has got a login and connection string to the database of the main site. it connects to the database successfully (otherwise it would give an error) but for whatever reason the faq.php ignores the data from the main site's tables and still prints out the data from its own database...huh?

i changed the include_once() command calling its own database into the above mentioned include() statement but somehow those variables are not getting replaced with the new information.

NOTE: if I change the configure file database connection details in the configure.php file of the satellite site to login into the main database then it works and the entire site's data is pulled from the main database, but this is not what i want because certain pages are of course site specific, whereas others such as faq and blog can be duplicates of the faq and blog from the main site.

Help is appreciated.

MarkR

Hey look, there's a bandwagon!

Quickly, jump on!

Mark

Quizboy

MarkR wrote:
Hey look, there's a bandwagon!

Quickly, jump on!

Mark

yes, that's right Mark. you've got the idea exactly. Just like Google did, and Yahoo before them...i'm doing my best to join the bandwagon jumpers

any ideas how to have the blog and faq from all my Million Dollar Homepage For... pages (20+ and counting) pull from the database of the main page?

Quizboy

it seems that once my site calls up the original configure file and applies variables to the database tables, those variables cannot again be rewritten by calling another database with tables of the same name. am i on the right track with this logic?

Quizboy

Well I got no help here or even an attempt to help, but that's ok.

I solved the problem for myself (as usual) by very quickly using SQL commands in phpMyAdmin to copy the contents of the faq and blog tables from the main site to all the rest of the sites. Shouldn't be too time consuming to just do it this way for a while...until i get the synch alternative working.

What I don't appreciate is that it looks like all i got for my trouble here is a hacker who attempted to hack my site and post images without paying. it didn't work but it's still not cool. agree or disagree with the worthiness of my business efforts, it's still my business and it's still my effort. I hope the attack didn't come from here, but it did happen within 4 hours of my posting here and at the ...people link which I had posted above.

Anyway I hope I can continue to trust this site as a friendly programming resource, as I have always seen it as such and spread the word as such.