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" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> 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:[EMAIL PROTECTED]
>
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
