Files
startup/inhalte/turnus_over.php

4 lines
499 B
PHP

<?php
$sql = "SELECT " . PREFIX . "_Reminder.Jahr, " . PREFIX . "_Reminder.ID, DATE_FORMAT(" . PREFIX . "_Reminder.Datum, '%d.%m.%Y') AS Datum, " . PREFIX . "_Kontakte.Firma, " . PREFIX . "_Kontakte.Nachname, " . PREFIX . "_Kontakte.Vorname FROM " . PREFIX . "_Reminder LEFT JOIN " . PREFIX . "_Kontakte ON " . PREFIX . "_Reminder.Kontakt_ID = " . PREFIX . "_Kontakte.ID " . $Abfrage . " ORDER BY " . PREFIX . "_Reminder.Datum ASC;";
$result = $db->query($sql);
include __DIR__ . "/sv_overview.php";