how do i store/retrieve xml data in a relational db ?

im working on an application that needs to work with xslt stylesheets. i thought the best way to do this would be to store the XML data in a relational database, eg MySQL. and work with it using PHP.

The intention is to query the MySQL database for data, and have XML generated which can then be XSLT processed.

Now how do i actually go about doing this please ? i have NO clue whatsoever.


if someone can provide sample code that would be most excellent (sorry to sound like a ninja turtle, i know theyre old)

well, if you have the information in there, you would need to query the database and get the results, and then have it print out the results in a xml document. I'm not sure about doing that in php. But that is what you'll have to do.

I'm assuming you want to make like a feed script? And then another script will read the xml data?

erm, whats a feed script ?

Feed script:
Queries the database and builds a response in xml (versus html, or text, or jpg).

Then you have another script which calls your feed script and does an xsl transform on the results.