I would like to create a RSS 2.0 feed that will pull a daily picture with some text from a database. This will be for my clients who subscribe to my feed on their msn/google/yahoo/etc. homepage. So the script needs to display the picture of the my clients homepage with the text right under it. I would like this process to be completely automated. So the picture will be named [login to view URL] and the text will be name [login to view URL] and it will place those together for day 1. Then on day 2 it will automatically update to [login to view URL] and [login to view URL]
On the admin side I need to be able to clear the numbering back to 1 again so I can update the pictures whenever I need to. (and I don't want to end up with [login to view URL] and [login to view URL])
The picture needs to automatically be a link back to my website and the text needs to be able to be a seperate link to another page on my site.