MySQL data to XML file

[pavmoxo]

Greetings!!!

How can I write Mysql data in a XML file using PHP for RSS??
Do you have examples??

[codeexploiter]

check the following tutorials

MySQL data to XML -1

MySQL data to XML -2

[pavmoxo]

Can a RSS reader read a php file for simulate a xml file??

[codeexploiter]

Can a RSS reader read a php file for simulate a xml file??

I didn't get your point ...

1) Why should an RSS reader read a PHP file to simulate an XML file?

You can run the script that convert mysql data into an XML file and and read that xml file using RSS reader script....

[alexjewell]

Oh, yeah. You use HTTP Headers to send out the file to be recognized as another file type even when it's PHP. I use it for my CSS stylesheets and JavaScripts - they're PHP files, but are recognized as CSS files and JavaScript files by the browser.

[nikomou]

i've just done this using a mySQL database... still need some help?

to solve the problem mentioned above, this is what i did:

create the rss feed using php
save the feed to an xml file
used cron to update the xml everyday