How to create XML using data from MySQL database?? the best way???

hi all

Now i need to generate XML i.e rss directly from MySql database. How can i do it?? When i googled for it, some of them was telling use ASP, use PHP etc...

Which is the best way??
and How to do it??
please provide me an Example code or good article you know, whatever you think that makes me understand.

I am not very good at PHP, but i can learn.

Thank you very much in advance

 

You will need to find out the structure of rss feeds (try wikipedia) then learn how to use php to pull data from the database and put it into the rss structure. Tizag is great for learning php and mysql.

 

Check this http://www.techrepublic.com/article/create-xml-with-mysql-and-php/5035149