Poules
// Get main categories
$pdo = DB::prepare("SELECT DISTINCT `hoofd_cat` AS `hoofd_cat` FROM `poules`");
$pdo->execute();
while ($row = $pdo->fetch(PDO::FETCH_LAZY))
{
?>
// Get Poules from Categorie
$pdo2 = DB::prepare("SELECT * FROM `poules` WHERE `hoofd_cat` = ?");
$pdo2->execute([$row['hoofd_cat']]);
while ($action = $pdo2->fetch(PDO::FETCH_LAZY))
{
// Table Top
$body = "";
$body .= "";
$body .= "";
$body .= "
";
$body .= " ";
print_r($body);
}
?>
} ?>
Poule " . $action['poule_naam'] . " | "; $body .= "||
---|---|---|
Inschrijven | "; } else { $body .= "- | "; } } else { // Team Name $pdo3 = DB::prepare("SELECT * FROM `inschrijvingen` WHERE `id` = ?"); $pdo3->execute([$action[$tno]]); $dbrow = $pdo3->fetch(PDO::FETCH_LAZY); $body .= "" . $dbrow['volledige_naam'] . " | "; } $body .= "