I'm just curious say we have a database with advertiser info. now how could I get this info to appear on other sites? What would be the easiest way for other sites to get this info. from our database? Would we just need to have them insert a small code on there website? Maybe mysql connection? I'm not sure if it would work like that or not..
One way could be to provide them with an URL to which the response is in XML format. For example, another site runs a server side script(in PHP or whatever) which request the page example.com?action=getAdvertiserData&ID=412 ...and your server make a response with: <advertiserdata> <item id="1234" type="adsense" value="567"/> </advertiserdata> Code (markup): Then they could do whatever needed with that data. Better than giving access to your database in my opinion. Depending on what they need to do with the data, you could actually return HTML so that no processing at all is done by the requesting server. Just return what you need the other server to display if that's the idea.
So basically just use XML to connect to my server or pass the data from my server to the advertiser site? You don't know of anything I could read that will point me in the right direction on this do you?
You can use Ajax requests from one domain to another to generate XML content on those sites. You would however have to develop routines on both environment. Routines to build XML content after consultation of the database on one side and routines on the site side to read this XML and present the data. Like zeroco said: xml request of example.com?action=getAdvertiserData&ID=412 for example. Among many you can read: http://www.hunlock.com/blogs/XML_For_N00bs,_AJAX_for_Gurus