Hi,
Wouldn’t it be nice if you could just type:
echo $modx->db->getXML("SELECT fname,lname FROM users");
and get the following output for use in you Ajax or XSLT web pages:
<xml>
<recordset>
<item>
<fname>Mary</fname>
<lname>Jane</lname>
</item>
<item>
<fname>John</fname>
<lname>Brown</lname>
</item>
</recordset>
</xml>
Well it’s all possible now with the new getXML() function inside the DBAPI
what do you think?