Code: Select all
$query = "SELECT showname, Details, ShowDate, ShowTime, URLText FROM $tb_name WHERE ShowDate >= GETDATE() ORDER BY showname";
$result = @mysql_query($query, $connection);
//Create XML Document
$dom = new DOMDocument("1.0");
$dom->formatOutput = true;
//Create root node
$root = $dom->createElement("list");
$dom->appendChild($root);
while($row = @mysql_fetch_assoc($result))
{
$occ = $dom->createElement($tb_name);
$root->appendChild($occ);
foreach ($row as $fieldname => $fieldvalue)
{
$child = $dom->createElement($fieldname);
$occ->appendChild($child);
$value = $dom->createTextNode($fieldvalue);
$child->appendChild($value);
}
}
echo $dom->saveXML();
$dom->save("xml.xml");
Thanks for taking time to give me advice.