Mcrosoft SQL Server and "for xml auto" queries

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



I've been trying for months to figure out how to get "for xml auto" queries
to work from PHP. I've got it working from ASP, which I strongly disprefer
(hate!).

I'd simply like to do:

$sql = "select * from customers for xml auto";
$xml = $mssql->execute($sql);
echo $xml

This should return:

<root>
   <customer id="1" name="Alfred Futt"/>
   <customer id="2" etc./>
</root>

Any help appreciated.

Daniel



-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux