<?php
require_once('../scoreboard/db_connect.php');

$query = "SELECT agentID, totalScore, FROM agentsScores";
$result = mysql_query($query);
?>
<!--HTML GEDEELTE VOOR TABEL-->
<table border="1">
 <tr>
  <th>Agent ID:</th>
  <th>Agent Lastname:</th>
  <th>Agent Firstname:</th>
  <th>Agent Score</th>
 </tr>

<?php
 if($result->num_rows > 0) { //kijk of er data in de tabel zit
  while($row = $result->fetch_object()) {
   echo "<tr>"; //maak een rij in de tabel
    echo "
     <td>" . $row->agentID . "</td>
     <td>" . $row->agentLast . "</td>
     <td>" . $row->agentLast . "</td>
     <td>" . $row->agentScore . "%</td>
    ";
   echo "</tr>"; //sluit de rij
  }
 } else { //als de tabel leeg is (geen data)
  echo "<b>There are no agents registered.</b>";
 }
?>