0) $str[$i] = '_'; } return $str; } function write_header() { $xml = ''; $xml .= "\n"; $xml .= "\n"; $xml .= "\n"; $xml .= "Calgary Scrabble Group - Tournaments\n"; $xml .= "http://www.calgary374.org/TournamentListPage.php\n"; $xml .= "Upcoming tournaments hosted by Calgary Scrabble Group as well as other nearby clubs.\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 .= "" . $row["name"] . "\n"; $url = "http://www.calgary374.org/TournamentPage.php?id=" . (string) $row["id"]; $xml .= "" . $url . "\n"; $xml .= "" . $url . "\n"; //$xml .= "" . $row["date"] . " " . date('O') . "\n"; $xml .= ""; $xml .= $row["dates"]; $xml .= " in "; $xml .= $row["city"]; $xml .= ", "; $xml .= $row["prov_state"]; $xml .= "
\n
\nAddress:
\n"; $xml .= $row["address"]; $xml .= "
\n
\nDetails:
\n"; $xml .= $row["details"]; $xml .= "]]>
\n"; $xml .= "
\n"; } return $xml; } function write_footer() { $xml = ''; $xml .= "
\n"; $xml .= "
\n"; return $xml; } f_connect(); $result = f_run_query("rs_events_current_with_details"); $xml = ''; $xml .= write_header(); $xml .= write_items($result); $xml .= write_footer(); header('Content-type: text/xml'); print $xml; mysql_free_result($result); f_disconnect(); ?>