results.php

<? if(!defined("CONFIG")) exit(); ?>
<? require_once("functions.php");
$link = mysqlconnect();
if ($link == null) {
	show_error("MySQL Error\n");
} else {
	$squery = "SELECT s.id, s.name, d.name dname, COUNT(r.id) racecount FROM season s JOIN division d ON (d.id = s.division) LEFT JOIN race r ON (r.season = s.id) GROUP BY s.id ORDER BY name ASC, dname ASC" ;
	$sresult = mysqli_query($link,$squery);
	if(!$sresult) {
		show_error("MySQL Error: " . mysqli_error($link) . "\n");
		return;
	}
	$rquery = "SELECT r.id, r.name, r.track, r.date, d.name dname, rs.name rsname, qrs.name qrsname FROM race r JOIN division d ON (r.division = d.id) JOIN point_ruleset rs ON (r.ruleset = rs.id) LEFT JOIN point_ruleset qrs ON (r.ruleset_qualifying = qrs.id) WHERE r.season='0' ORDER BY r.date ASC" ;
	$rresult = mysqli_query($link,$rquery);
	if(!$rresult) {
		show_error("MySQL Error: " . mysqli_error() . "\n");
		return;
	}
}
?>
<h1>Results</h1>
<h2>Seasons</h2>
<div class="w3-container">
<div class="w3-responsive">
<table class="w3-table-all">
<tr class="w3-dark-grey">
	<td>Season</td>
	<td>Division</td>
	<td>Races</td>
</tr>
<?
while($sitem = mysqli_fetch_array($sresult)) { ?>

<tr class="w3-hover-green">
	<td><a href=".?page=result_season&amp;season=<?=$sitem['id']?>"><?=$sitem['name']?></a></td>
	<td><?=$sitem['dname']?></td>
	<td><?=$sitem['racecount']?></td>
</tr>
<?
}
?>
</table>
</div>
</div>

<h2>Events</h2>
<div class="w3-container">
<div class="w3-responsive">
<table class="w3-table-all">
<tr class="w3-dark-grey">
	<td>Name</td>
	<td>Track</td>
	<td>Date</td>
	<td>Division</td>
	<td>Ruleset</td>
</tr>
<?

while($ritem = mysqli_fetch_array($rresult)) {
	$date = strtotime($ritem['date']);
	?>

<tr class="w3-hover-green">
	<td><a href=".?page=result_race&amp;race=<?=$ritem['id']?>"><?=$ritem['name']?></a></td>
	<td><?=$ritem['track']?></td>
	<td><?=date("d M Y", $date)?></td>
	<td><?=$ritem['dname']?></td>
	<td><?=$ritem['rsname']?><?=isset($ritem['qrsname']) ? " / " . $ritem['qrsname'] : ""?></td>
</tr>
<?
}
?>
</table>
</div>
</div>