MySQL data into XML for DW CS3

Joe Makowiec wrote:
> I don't have time to look it up at the moment, but if memory serves,
> MySQL has built-in XML export facilities.

It does, but you need to invoke XML export from the command line.

It's quite easy to generate XML with PHP:

http://labs.adobe.com/technologies/spry/samples/utils/query2xml.html

I have tested Spry with on-the-fly XML generated by PHP from MySQL. It
works without problem.

--
David Powers, Adobe Community Expert
Author, "Foundation PHP for Dreamweaver 8" (friends of ED)
Author, "PHP Solutions" (friends of ED)
http://foundationphp.com/

On 01 Apr 2007 in macromedia.dreamweaver.appdev, lazlo2005 wrote:

> I have been developing mainly with the MySQL/ php frameworks, but am
> keen to integrate MySQL data via SPRY. if I understand correctly,
> data can only be in XML format to be available for the SPRY
> features.
>
> So my question is, how can/ what is the best practise for creating
> XML data from a MySQL database, one that does not have to be
> exported/processed by a user everytime data changes in the db.

I don't have time to look it up at the moment, but if memory serves,
MySQL has built-in XML export facilities.

http://dev.mysql.com/

--
Joe Makowiec
http://makowiec.net/
Email: http://makowiec.net/contact.php