I've recently completed two projects -- the first was a phpBB extension utilizing new querys with MySQL and the second was an ASP utilizing SQLServer 2000 with XML and XSL transforms.
I am onto a new project and would love to utilize PHP and MySQL where the result set from MySQL is in XML format so that I can process it with XSL transforms. SQLServer 2000 can return an XML formatted result set and I found this ideal for my last project -- can MySQL do the same or is there a PHP class out there that will take a MySQL result set and convert it to XML?

TIA,

When starting the mysql client program, add the option -X and
your output will be formatted as XML.

Thanx very much

I am not using the mysql client utility but instead connecting to the server and running queries from a PHP application.

Can I get XML like the mysql client program is?

As far as I'm aware, XML output is only provided by the mysql
client program and the mysqldump program, not the server itself.