Re: XML Strategdy

Try Krysalis (http://www.interakt.ro/products/Krysalis/) if you're trying something more complex. It's a PHP/XML platform. If you want simple stuff (just generate XML's), I recomend doing for yourself a custom class/function for it. Here is a code sample: <psql:execute-query connection="krysalis"> <psql:query> select * from department_dep inner join employee_emp on iddep_emp = id_dep order by id_dep </psql:query> <psql:results> <psql:row-results> <department> <id><psql:get-string column="id_dep"/>/id> <name><psql:get-string column="name_dep"/>/name> <!-- get the employees for the same department--> <psql:row-results field="id_dep> <employee> <id><psql:get-string column="id_emp"/></id> <name><psql:get-string column="name_emp"/></name> </employee> </psql:row-results> </department> </psql:row-results> </psql:results> </psql:execute-query> "Mark Roberts" <phplist@robertscomputing.com> wrote in message news:OFEIJHBPMMPKIOEGIMAIIEEPGFAA.phplist@robertscomputing.com... > I am about to embark on a project that requires me to access several mysql > files (customer order entry), gather the information and output an XML > formatted file that will be used as an input file to another accounting > application. > > Question is this. As a seasoned developer, my natural instinct is to just > write a script(s) to access all the information that I need and write the > appropriate information out to the file. Is there a better way to do this? > Is there some type of application that has been developed that will take a > select statement as input and automatically generate XML output? > > Just courious...any suggestions, thoughts, comments? > > Thanks. > Mark Roberts, Roberts Computing Systems > Webmaster Services $29.50/mo > > > > mailto:mark.roberts@robertscomputing.com > >