Lichfield Nomads Cricket Club - 2017 Fixtures
Played 0; Won 0; Lost 0; Draws 0; Cancelled 0
connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT MatchDate, StartTime, Venue, OppositionName, Scores, ResultText FROM Matches WHERE Year = 2017";
$result = $conn->query($sql);
if ($result->num_rows > 0) {
echo "
Date | Start | Venue | Opposition | Scores | Result |
";
// output data of each row
while($row = $result->fetch_assoc()) {
echo "".$row["MatchDate"]." | ".$row["StartTime"]." | ".$row["Venue"]." | ".$row["OppositionName"]." | ".$row["Scores"]." | ".$row["ResultText"]." |
";
}
echo "
";
} else {
echo "0 results";
}
$conn->close();
?>
02/04/2018