resultset to xml

Hey guys,

I am wondering if there is a module that when I query the database and
it returns the resultset in xml format.

eg. select name,gener from user;

will return
<results>
<result>
<name>James</name>
<gender>male</gender>
</result>
<result>
<name>Mary</name>
<gender>female</gener>
</result>
</results>

re: resultset to xml

the best thing to do is use a third party module to interpret the data
im pretty sure that php/apache has one and there are other libraries
out there for c
you may even want to create a custom library to do this(i would highly
recommend it)