Originally Posted by jakesee

Help with Code Tags

PHP Syntax (Toggle Plain Text)

// create the XML data 
$xmlData = CreateSomeXMLFromSQL();
 
// tell the browser its XML
header("content-type: text/xml");
 
echo $xmlData;

// create the XML data $xmlData = CreateSomeXMLFromSQL(); // tell the browser its XML header("content-type: text/xml"); echo $xmlData;

Originally Posted by jakesee

XML is a method of writing a document, not a template document that you just insert values and then dislay.

in this regard, you need to write your own XML.

MySQL is the database and SQL is the language for querying (instructing, commanding) the database to do something. Depending on which one you are talking about, these are for data storage and retrieval. They have nothing to do with XML.

To create your own XML means you need to take the data and format it in the XML way.

Displaying it as XML in the web browser means sending the php header() before printing the text.

I think you need to read more about what is XML first http://www.w3schools.com/xml/default.asp

Then write your own XML, storing it in a php variable such as $xmlData and then finally output it using the code provided previously.