\n" ."\n"; $query = " SELECT `url`, `lastmod`, `changefreq`, `priority` FROM `sitemap` ORDER BY `url` ASC"; $result = mysql_query($query, $_DB["site"]); while($row = mysql_fetch_assoc($result)){ $xml .= "\t\n" ."\t\thttp://".$_SERVER['HTTP_HOST'].htmlentities($row["url"])."\n" ."\t\t".$row["lastmod"]."\n" ."\t\t".$row["changefreq"]."\n" ."\t\t".$row["priority"]."\n" ."\t\n"; } $xml .= ""; echo $xml; ?>