I have a MySQL table that holds extracted data from an RSS feed, such as description, price, photo and video URLs, etc
The items of the RSS feed can fluctuate from time to time, i.e. the price can change, the description can change, also items can be removed and added to the RSS feed.
What I'm looking for is a script that will detect all the changes made to the RSS feeds that are in my MySQL table and either insert new records, update existing records or delete ones that are no longer in the RSS feed.
I can provide all details for you, including an SQL dump and the RSS feeds for you to parse.
I need a speedy turnaround for this as I have a deadline for early next week.