PDA

View Full Version : Generate XML/RSS with database items.



lefonk
February 19th, 2007, 08:46 PM
Hello All,
First of all:
I seek for houres. But i couldn't find something.
And my server can't run php5.

But i think it's very easy what i want.

I have a table in my sql db. It contains:
ID
Title
Message
Date
Link

I want a simple php script that generate


<?xml version="1.0" encoding="ISO-8859-1"?>

<rss version="2.0">
<channel>
<title>Messages</title>
<link>mysite.nl</link>
<description>messages from the database</description>
<item>
<title> item one from database</title>
<link>item one from database</link>
<message>item one from database</message>
<pubDate>item one from database</pubDate>
</item>
</channel>
</rss>

Who can help me?
thanks in advance!

lefonk
February 19th, 2007, 08:53 PM
I think i found it.
http://www.kirupa.com/web/mysql_xml_php.htm