Tournament Results
include('global_vars.php');
$link=mysql_connect($host, $user, $pw) or die(mysql_error());
mysql_select_db($db) or die(mysql_error());
$query = "SELECT r_doc_name, r_link_caption FROM results ORDER BY r_order_ref";
$result = mysql_query($query, $link);
$num=mysql_numrows($result);
?>
if($num) {
// display docuemnt links
for($i=0;$i<$num;$i++) {
$doc_name = mysql_result($result,$i,"r_doc_name");
$link_caption = mysql_result($result,$i,"r_link_caption");
echo("
");
echo("$link_caption");
echo("");
echo("
");
}
}
else { ?>
There are currently no results.
}
// close the connection
mysql_close();
?>