mySQL -> PHP -> XML

[abritez]

i'm looking to find out how to query a database and output XML. I've seen it done hard coded but i was wondering if there was any way to do it like the code below. It is in ASP I'm now migrating to PHP though.

I'm sure there is a way to do it this way, but haven't been able to find any examples.

<%@ Language=VBScript %>
<%

vendorType = Request.QueryString("vendorType")
vendorState = Request.QueryString("vendorState")


s=chr(10)
Set cn = Server.CreateObject ("ADODB.Connection")
'cn.ConnectionString = "pycDB2"
cn.Open "driver={Microsoft Access Driver (*.mdb)};DBQ=" & Left(Request.ServerVariables("PATH_TRANSLATED"),InStrRev(Request.ServerVariables("PATH_TRANSLATED"), "\")) & "login.mdb"



Set cmd = Server. CreateObject ("ADODB.Command")
cmd.ActiveConnection = cn
cmd.CommandType = 1
cmd.CommandText = "SELECT * FROM tblVendors WHERE Vendor_state='" & vendorState & "' and Vendor_type ='" & vendorType & "' ORDER BY Vendor_name"

Set rs = cmd.Execute

Set objXML = Server.CreateObject("MSXML.DOMDocument")

Set elm = objXML.createElement("calander")
objXML.appendChild elm

Do Until rs.EOF
	Set elm = objXML.createElement("events")
	elm.setAttribute "where", rs("Vendor_name")
	elm.setAttribute "genre", rs("Vendor_shortDisc")
	elm.setAttribute "address", rs("Vendor_address")
	elm.setAttribute "city", rs("Vendor_city")
	elm.setAttribute "state", rs("Vendor_state")
	elm.setAttribute "discount", rs("Vendor_discount")

objXML.firstChild.appendChild elm

rs.MoveNext
Loop

Response.Write ("<?xml version=""1.0"" encoding=""UTF-8""?>" & objXML.xml)
%>

[abritez]

okay I read up on this a bit and found that the DOM XML functions are experimental. What are the chances that this will be set as part of the standard and when? I would much rather use the function instead of printing to screen.

here is the documentation:
http://www.php.net/manual/en/ref.domxml.php

Here is the print to screen cheater way to do it, havent tested it but it should work i think, i hope.

<?php


/* open your mysql connection */
mysql_pconnect("hostname","username","password");

$sql = "
	SELECT * 
	FROM tblVendors 
	WHERE Vendor_state='$vendorState' 
	AND Vendor_type = '$vendorType' 
	ORDER BY Vendor_name
";
$query = mysql_query( $sql );


echo '<xml>';

/* loop through the records you got from the DB */

while( $row = mysql_fetch_array($query) ) {
	echo '<attribute name="where" value="'.$row['Vendor_name'].'">';
	echo '<attribute name="genre" value="'.$row['Vendor_shortDisc'].'">';
	/* and so on for each item in the record set you need to grab */
}


echo '</xml>';

?>