Livetiming

= CURRENT_DATE() ORDER BY datum ASC”;
$result = mysqli_query($verbinding, $sql) or die (mysqli_error());
echo ‘

‘;
while($object = mysqli_fetch_assoc($result))
{
echo “

“;
}
echo “

“;
$sql = “SELECT DATE_FORMAT(datum, ‘%d-%m-%Y’) AS datumNL, wedstrijd, id FROM livetiming WHERE datum < CURRENT_DATE() ORDER BY datum DESC"; $result = mysqli_query($verbinding, $sql) or die (mysqli_error()); while($object = mysqli_fetch_assoc($result)) { echo "

“;
}
echo “

“.$object[‘datumNL’].”

“.$object[‘wedstrijd’].”

Archief

“.$object[‘datumNL’].”

“.$object[‘wedstrijd’].”

“;
}
else
{
$sql = “SELECT DATE_FORMAT(datum, ‘%d-%m-%Y’) AS datumNL, wedstrijd, link FROM livetiming WHERE id = “.$_GET[‘id’];
$result = mysqli_query($verbinding, $sql) or die (mysqli_error());
while($object = mysqli_fetch_assoc($result))
{
echo ‘
‘;
}
}
?>