\n"; $xml .= "\n"; $xml .= "\n"; $xml .= "Calgary Scrabble Group - News\n"; $xml .= "http://www.calgary374.org/\n"; $xml .= "Latest news items from the Calgary Scrabble Group web site.\n"; $xml .= "" . date("r") . "\n"; $xml .= "en-us\n"; return $xml; } function write_items($result) { $xml = ''; $n = mysql_num_rows($result); for ($i = 0; $i < $n ; $i++) { $row = mysql_fetch_array($result); $xml .= "\n"; $xml .= "" . htmlspecialchars($row["title"]) . "\n"; $url = "http://www.calgary374.org/NewsArticlePage.php?id=" . (string) $row["id"]; $xml .= "" . $url . "\n"; $xml .= "" . $url . "\n"; $xml .= "" . $row["date"] . " " . date('O') . "\n"; $xml .= "\n"; $xml .= "\n"; } return $xml; } function write_footer() { $xml = ''; $xml .= "\n"; $xml .= "\n"; return $xml; } f_connect(); $result = f_run_query("rs_news_articles_with_text"); $xml = ''; $xml .= write_header(); $xml .= write_items($result); $xml .= write_footer(); header('Content-type: text/xml'); print $xml; mysql_free_result($result); f_disconnect(); ?>