# Generate XML/RSS with database items

**URL:** <https://forum.kirupa.com/t/generate-xml-rss-with-database-items/216724>\
**Category:** Uncategorized\
**Created:** [February 20, 2007, 12:46am UTC](https://forum.kirupa.com/t/generate-xml-rss-with-database-items/216724 "2007-02-20T00:46:20Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![lefonk](https://avatars.discourse-cdn.com/v4/letter/l/13edae/32.png) [@lefonk](https://forum.kirupa.com/u/lefonk)\
**Post date:** [February 20, 2007, 12:46am UTC](https://forum.kirupa.com/t/generate-xml-rss-with-database-items/216724/1 "2007-02-20T00:46:20Z")

</div>

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:  
[SIZE=1]ID  
Title  
Message  
Date  
Link[/SIZE]

I want a simple php script that generate

```auto

<?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!