<?php
   $conn= mysqli_connect( $dbhost, $dbuser, $dbpass, $db );
    if ($conn->connect_error) {
     die("Connection failed: " . $conn->connect_error);
    }

    $sql = "SELECT Date, Voltage, Current FROM DataTable WHERE ID='A' ORDER BY Date DESC";

    $result = $conn->query($sql);
//$i is used to assign serial number for each row
    $i=1;
    if ($result->num_rows > 0) {
     while($row = $result->fetch_assoc()) {
    echo "<form action = 'samepage.php' method =get>";

        echo "<tr>

            <td>" . $i. "</td>
            <td>" . $row["Time"]. "</td>
            <td>" . $row["Voltage"] . "</td>
            <td>" . $row["Current"]. "</td>
            <td>"." <input type=hidden  name=serialSelected value =" . $i."</td>
            <td>"." <input type=submit    name=Submit value=select >"."  </td>
        </tr>";
        $i++;
    echo "</form>";
  }
  echo "</table>";
  } else { echo "0 results"; }

  $avgCurrent=0;
  $avgVoltage=0;


  if(isset ($_GET['serialSelected'])){
//how to choose the value selected and the previous 4 values (total 5 values for avg calculation)

}