require “./points/config.php”; // Database connection
//require “config.php”; // Database connection
// $count=”SELECT id, position, driver, race1, race2, race3, bonus, Total, sum(race1 + race2 + race3 + bonus) as total from outlaw10_5xl Group By Total DESC “;
$count=”SELECT id, driver, race1, race2, race3, bonus, Total, FIND_IN_SET( Total, (
SELECT GROUP_CONCAT( DISTINCT Total
ORDER BY Total DESC )
FROM outlaw10_5xl )
) AS rank
FROM outlaw10_5xl ORDER BY Total DESC “;

echo “<div class=’Table’>”;
echo “<div class=’Heading’>”;
echo “<div class=’Cell’>
<p>Rank</p>
</div>”;
echo “<div class=’Cell’>
<p>Driver/Team Name</p>
</div>”;
echo “<div class=’Cell’>
<p>Race 1</p>
</div>”;

echo “<div class=’Cell’>
<p>Race 2</p>
</div>”;
echo “<div class=’Cell’>
<p>Race 3</p>
</div>”;
echo “<div class=’Cell’>
<p>Bonus</p>
</div>”;
echo “<div class=’Cell’>
<p>Totals</p>
</div>”;

echo “</div>”;

foreach ($dbo->query($count) as $row) {
echo “<div class=’Row’>”;
echo “<div class=’Cell’>$row[rank]</div>”;
echo “<div class=’Cell’>$row[driver]</div>”;
echo “<div class=’Cell’>$row[race1]</div>”;
echo “<div class=’Cell’>$row[race2]</div>”;
echo “<div class=’Cell’>$row[race3]</div>”;
echo “<div class=’Cell’>$row[bonus]</div>”;
echo “<div class=’Cell’>$row[Total]</div>”;
echo “</div>”;

mysqli_free_result($result);
}
echo “</div>”;
echo “</div>”;
echo “</div>”;