Statistics'; echo ''; /**************** * MENCS * ****************/ $did = $_GET['did']; echo '

FULL STATS


'; echo '

2021-2022 Season Monster Energy Cup Statistics

'; echo '
'; $db = new mysqli("localhost", $username, $password, $database); if($db->connect_errno > 0){ die('Unable to connect to database [' . $db->connect_error . ']'); } /*echo '

'; $current = ("SELECT * FROM res LEFT JOIN drivers on res.did = drivers.did LEFT JOIN tracks on res.tid = tracks.tid") or die(mysql_error()); if(!$result = $db->query($current)){ die('There was an error running the query [' . $db->error . ']'); } $row = $result->fetch_array(); $did = $row['did']; $track = $row['track']; $poles = $row['poles']; $points = $row['points']; $driver = $row['driver']; $finished = $row['finished']; $t5 = $row['t5']; $t10 = $row['t10']; echo '

*/ echo ''; $race = ("SELECT * FROM res LEFT JOIN drivers on res.did = drivers.did LEFT JOIN points on res.did = points.did where drivers.did = '$did'"); if(!$result = $db->query($race)){ die('There was an error running the query [' . $db->error . ']'); } $row = $result->fetch_array(); $did = $row['did']; $track = $row['track']; $poles = $row['poles']; $points = $row['points']; $driver = $row['driver']; $finished = $row['finished']; $t5 = $row['t5']; $t10 = $row['t10']; echo '
Driver Points Wins Poles Top 5`s Top 10`s DNF`S DNS`S
'.$driver.' '; /**************** * Points System * ****************/ $sql=("SELECT * FROM points LEFT JOIN drivers on points.did = drivers.did where points.did='$did'"); $result = mysqli_query($db,$sql); while ($row = mysqli_fetch_assoc($result)) { echo $points; } echo ' '; /************** * Wins System * **************/ $sqlw=("SELECT sum(finished) as wins FROM res where did='$did' AND finished = 1"); $result = mysqli_query($db,$sqlw); while ($row = mysqli_fetch_assoc($result)) { if($row['wins'] == 0){ echo '0'; } else { echo $row['wins']; } } echo ''; /*************** * Poles System * ***************/ $sqlp=("SELECT count(pole) as poles FROM res LEFT JOIN drivers on res.did = drivers.did where res.did='$did' and pole = 1"); $result = mysqli_query($db,$sqlp); while ($row = mysqli_fetch_assoc($result)) { echo $row['poles']; } /*$sqlw=("SELECT sum(finished) as wins FROM res where did='$did' AND finished = 1"); $result = mysqli_query($db,$sqlw); while ($row = mysqli_fetch_assoc($result)) { echo $row['wins']; }*/ echo ''; /***************** * Top 5`s Totals * *****************/ $sql3=("SELECT sum(t5) as t5 FROM res where did='$did'"); $result = mysqli_query($db,$sql3); while ($row = mysqli_fetch_assoc($result)) { echo $row['t5']; } echo ''; /****************** * Top 10`s Totals * ******************/ $sql4=("SELECT sum(t10) as t10 FROM res where did='$did'"); $result = mysqli_query($db,$sql4); while ($row = mysqli_fetch_assoc($result)) { echo $row['t10']; } echo ''; /************* * DNF Totals * *************/ $sqldnf=("SELECT sum(dnf) as dnfs FROM res where did='$did'"); $result = mysqli_query($db,$sqldnf); while ($row = mysqli_fetch_assoc($result)) { echo $row['dnfs']; } echo ''; /*************** * DNS`s Totals * ***************/ $sql5=("SELECT sum(dns) as dns FROM res where did='$did'"); $result = mysqli_query($db,$sql5); while ($row = mysqli_fetch_assoc($result)) { echo $row['dns']; } echo '

'; //} //} ?>