sql test

<PHP>

  $servername = "localhost";
  $username = "root";
  $password = "i18wZJQGe2WDyFSF9X0y";
  $dbname = "availability";

  // Create connection
  $conn = mysqli_connect($servername, $username, $password, $dbname);
  // Check connection
  if (!$conn) {
      die("Connection failed: " . mysqli_connect_error());
  }

  $sql = "SELECT * FROM tsd";
  $result = mysqli_query($conn, $sql);

  if (mysqli_num_rows($result) > 0) {
      // output data of each row
      while($row = mysqli_fetch_assoc($result)) {
          echo "<p style='font-weight:bold;font-size:16px;'>";
          echo $row["agent"].": ";
          echo "</p>";
          echo "<blockquote style='font-size:16px;border-style:solid;border-width:1px;border-color:#cbcbcb;background:#f5f5f5'>";
          echo $row["status"];
          echo "</blockquote><hr>";
      }
  } else {
      echo "0 results";
  }

  mysqli_close($conn);

</PHP>—- If you have any further questions, or if you are ever unsure about what to do, please contact TSD at help@mysouthland.com.