I'm posting this in the DB forum as well.
Here's my issue:
1) My domain (let's call it "MAIN.com") has a MySQL table (several, actually, but lets be basic) hosting news items (not necessarily news, but we'll go with that).
2) Several partnering domains host their own databases of news items (please remember, we're not necessarily talking news, it could be recipies too). I have exported their MySQL data into XML files on their domain (each site uses "SITENAME.xml" as the filename of their exported xml file).
3) I need to take the SITENAME.xml files and merge them with my MAIN.com MySQL database.
4) (bonus). The extended goal is to send updated "recipies" to the partnering domains, allowing them to show the data on their websites. Taking this idea further would be adding websties w/out databases and showing the merged data (sorted for each domains use) in XML, or even flat HTML display (for say, geocities sites).
So far, I've completed my MySQL structure, and XML output from several partner domains.
Next, I need to figure out how to import the XML data into my MAIN.com MySQL database, and how to exchange the data back to the partner domains.
Any pointers?
