$file= fopen("results.xml", "w");

 $_xml ="<?xml version=\"1.0\" encoding=\"UTF-8\" ?>\r\n";

 $_xml .="<site>\r\n";

 while ($row = mysql_fetch_array($result)) {

 if ($row["pageTitle"]) {

 $_xml .="\t<page title=\"" . $row["pageTitle"] . "\">\r\n";

 $_xml .="\t\t<file>" . $row["pageLink"] . "</file>\r\n";
$_xml .="\t</page>\r\n";
 } else {

 $_xml .="\t<page title=\"Nothing Returned\">\r\n";
$_xml .="\t\t<file>none</file>\r\n";

 $_xml .="\t</page>\r\n";
 } }

 $_xml .="</site>";

 fwrite($file, $_xml);

 fclose($file);

 echo "XML has been written.  <a href=\"results.xml\">View the XML.</a>";