Automatically insert RSS feed into MySQL

[malinky]

I am a new developer and am building an online store for a client. He currently downloads an XML document containing stock level information and i have written a script to update the database from this. To do this he must place the XML document onto the host server and run the script.

He has told me today that there is an RSS feed containting stock information and has asked if its possible to automatically update the database, daily, from this feed. I dont understand if this can be done directly from the feed or where to start if its possible. Any advice would be appreciated?

[jkmyoung]

There's a variety of languages you can use. Please specify a preferred one.

1. Create an HTTP Request for the RSS feed.
2. Send the request to the RSS server, and get the rss feed back as a response.
3. Save the result to server.
4. Run the script.

[malinky]

I would like to do this with PHP.

[jkmyoung]

Thread moved to php forum.

[Daniel Iversen]

Its done here;

http://code.google.com/p/rssingest/

- its PHP code to parse RSS and insert into MySQL table - "just works" ;)