A new site I am working on is being supplied with a news feed as XML. The feed is being FTP'd onto my server daily and each feed has a different filename.
I need to be able to dump the contents into MySql but I have little idea where to start. I have done something similar in the past using a perl script to read plain text files as a cron job but I would be interested to know if anyone has been successful using PHP and XML.
Each document contains about 10 news stories but I need to separate them to add to the database individually which further complicates matters.
Any help would be appreciated
I need to be able to dump the contents into MySql but I have little idea where to start. I have done something similar in the past using a perl script to read plain text files as a cron job but I would be interested to know if anyone has been successful using PHP and XML.
Each document contains about 10 news stories but I need to separate them to add to the database individually which further complicates matters.
Any help would be appreciated