okay, how can i make a simple RSS feed depending on a query like this:

PHP Code:

mysql_query("SELECT * FROM events WHERE type='1' ORDER BY date DESC"); 


im a bit clueless what i have seems so confusing!

Basically you need to use PHP to create an RSS formatted page.

There are two ways you can do this.

1.Every time you create a new item you could update an rss file using PHP
2.You could generate the feed dynamically using PHP

Depending on the nature of the site you should use different techniques. For example, if the site gets updated consistetly then it might be better to make it dynamic, however is the site gets updated periodically (every day, week etc.) then it makes more sense to have the file updated after every news item.

Here is a basic look at how the first technique can be implemented: http://lowendmac.com/tech/php16.html

And here is how to produce one dynamically: http://www.phpfreaks.com/tutorials/139/3.php

Hope that helps.

Jamie

There's a good tute here that includes a more or less ready to use php/mysql rss script

THANKS! Dan that link was perfect, nice and simple.

okay can someone help me some more.

how can i have a clickable link?