RMSS
CHAMPIONSHIP POINTS
<!DOCTYPE html>
<html>
<head>
<meta name="viewport" content="width=device-width, initial-scale=1">
<style>
.collapsible {
background-color: #000000;
color: #ffffff;
cursor: pointer;
padding: 18px;
width: 100%;
border: 1px;
text-align: left;
outline: none;
font-size: 12px;
}
.hoverTable{
width:100%;
border-collapse:collapse;
color: white;
}
.hoverTable td:hover {
padding:7px; border:#4e95f4 1px solid; color: black;
}
/* Define the default color for all the table rows */
.hoverTable th, tr{
/* background: #b8d1f3; */
background: #000000;
}
/* Define the hover highlight color for the table row */
.hoverTable tr:hover {
background-color: #ffffff;
color: black;
}
th,tr,td {
/* border-top: 1px solid #ddd; */
/*border-right:0px solid #ccc;
border-bottom:1px solid #ccc; */
padding: 12px;
/*border:1px solid #ccc;*/
border-bottom:1px solid #ccc; */
border-top: 1px solid #ddd;
border-right:1px solid #ccc; */
border-left: 1px solid #ddd;
width: 20%;
}
th {
color: #ffffff;
font-size: 14px;
}
.content {
padding: 0 18px;
display: none;
overflow: hidden;
background-color: #f1f1f1;
}
div {
padding: 15px;
}
</style>
</head>
<body>
XDR
<?Php
require "./points/config.php"; // Database connection
//require "config.php"; // Database connection
$count="SELECT id, driver, race1, race2, race3, Total, sum(race1 + race2 + race3) as total from xdr Group By Total DESC ";
echo "<table class='hoverTable' width='700'>";
echo "<div>";
echo "<th> Driver</th><th>Race 1</th><th>Race 2</th><th>Race 3</th><th>Total Points</th>";
foreach ($dbo->query($count) as $row) {
echo "<tr><td>$row[driver]</td><td>$row[race1]</td><td>$row[race2]</td><td>$row[race3]</td><td>$row[Total]</td></tr>";
mysqli_free_result($result);
}
echo "</table>";
echo "</div>";
?>
