Newbie - PHP to RSS Help

[Jasoncy]

Well this is my first ever post and I need help!

 

Basically I have a few websites that are PHP - MYSQL driven on apache servers.

 

I am sure this is simple for you guru's but I have no hair left just keep trying and failing.

 

I have a fair understanding of html and a bit of sql but I cannot get any examples I have found to work so please if someone can show me how to do this for one of my sites, I am sure I will be able to adapt the script to work elsewhere.

 

The first site in question is http://www.cysecurity.co.uk/freelancer/

I am trying to create and RSS feed of the "featured" projects http://www.cysecurity.co.uk/freelancer/featured.php

 

Whic is performing a query similare to "SELECT * FROM freelancers_projects WHERE status='open' and special='featured' ORDER BY date2 DESC"

 

So ideally I want the RSS feed to do the same query and update each time a new project is featured.

 

I have seen so many similar script examples but I have now got to the point of frustration.

 

HELP

 

TIA