[PHP-DB] Mcrosoft SQL Server and for xml auto queries

[Daniel Cher]

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

[PHP-DB] for xml auto from MS Sql Server

[Daniel Cher]

Folks,

I'd like to use Microsoft SQL Server 2000 XML capabilities for generating
query results in XML. It is very easy, just say for xml auto at the end of
your query.

The problem is that I cannot seem to retrieve the results back into PHP.
Anyone ever accomplish this?

Daniel



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