convert resultset to XML?

[phatcher]

I'm pulling data from a db2 dbase via an odbc call. I would like to convert the recordset to an xml document. Is this possible, and how can I do this?
TIA
Patrick

[IWS]

Sure its possible.

example:

echo "<dataset>\n";
while ($row = odbc_fetch_row($res)) {
echo "<row><fld1>$row[0]</fld1><fld2>$row[1]</fld2></row>\n";
}
echo "</dataset>\n";

[phatcher]

Thanks!!

Originally posted by IWS
Sure its possible.

example:

echo "<dataset>\n";
while ($row = odbc_fetch_row($res)) {
echo "<row><fld1>$row[0]</fld1><fld2>$row[1]</fld2></row>\n";
}
echo "</dataset>\n";