xml feed into php/MYSQL listings site - noob question(s)
i have a listings site that runs php from mysql results, all good
but now I want to take an xml feed from a client with hundreds of live listings
all new to me and i want to be sure I have the big picture right before plunging in
am I right to think that I give them an XML template which is really just a list of the fields I need and the tags for each, so more or less what I'd get from my current MYSQL query, data and markup wise?
So when my regular MYSQL query runs, I also pull the xml data from their site (or from a cache of that feed), parse it and then merge it with the array from MYSQL, on the fly server side, and then carry on as before?
Is it that simple and are there any noob dos and don'ts?