Re: XML/MySQL

If I were you I'd just join strings- it's much less resource intensive. Just make sure you're using valid XML. On Sunday 26 October 2003 12:08 pm, Ian Williams wrote: > Apologies to anyone also subscribed to php.xml.dev, who will have read this > earlier, but it doesn't seem as frequently read as this news group... so I > am reposting... > > > Hi > I want to write a function that will take any SQL query as a parameter, and > generate XML that represents the recordset. > > e.g. "SELECT * FROM Customers" > > returns: > > <recordset> > <record id="1" name="Mr Smith" purchases="2"/> > <record id="2" name="Mr Jones" purchases="25"/> > <record id="3" name="Mr Davis" purchases="7"/> > </recordset> > > There are two approaches I think. One is to use the XML DOM, the other is > simply to join lots of strings together. What is the best approach? > > Thanks (and this is my first post to a newsgroup, and my first post to this > one, so excuse me if I've missed something vital!) > > cheers > ian ;-) -- Evan Nemerson evan@coeus-group.com -- "The people are the only sure reliance for preservation of our liberty." -Thomas Jefferson