I apologize in advance if this is a simple question that I should just know, but I really haven't run into this before, so I'm going to pose it here hoping someone can offer a quick answer when you get a chance.
Is there a way to have a "variable" in a WPMultiSite page that can pull information from the respective underlying MySQL table associated with the specific subsite? To explain better, I have set up this MultiSite application where when you put the information in the main site (the Deal), it mirrors the content to the designeated subsites (basically a copy of the deal). Each of the subsites will basically be an affiliate site dedicated to the specific affiliate promoting that "deal" on that subsite.
So on subsite "A" that may be for a group called PGP and they would be an affiliate for every deal that gets pushed to their subsite. I can go to each subsite and modify the "BUY" button link so that it handles their respective affiliate code properly, BUT, if I could just have a variable in the main site that when mirrored to the subsite would insert the affiliate code associated with that vendor for that subsite, the my job would be so much easier. Otherwise, I'll have to visit each subsite to add the affiliate codes.
I had considered writing some custom PHP to operate on the MySQL database and handle all of this - and I may still take that approach - but if there's a simple way to do it while the number of affiliates is low, I would love a simple way to get it going and then work on the more complex PHP code to better automate it.
The other day, I just powered up Navicat and went straight to the tables to take care of it.
Thanks in advance for the help/suggestions.