converting xml RSS feed into SQL insert?

[natanshar]

I am trying to set up a News Aggregator on a particular sports team. I think the best way to go about getting a wide variety of stories, while still maintaining control over the content, would be to get RSS feeds from the major news aggregators and import those stories into my SQL DB using PHP. At that point, an administrator can choose which stories to display and which to delete.

The part that I am clueless on is the conversion from an RSS feed to the SQL database. I assume that what I need to do is convert the RSS results (100 stories or so, from around the country) into a php array, and then I can run one big insert statement into the database.

Am I on the right track here? Iff so, can someone point me in the right direction to convert the RSS feeds into an array using PHP?

[phparion]

you can read simpleXML manual for PHP5 [php.net]

[edited by: coopster at 3:30 pm (utc) on Jan. 15, 2008]
[edit reason] removed non-authoritative url [/edit]

[phparion]

one other way could be to import your rss feed into access and then to sql from access.