Files
startup/inhalte/gut_over.php

4 lines
491 B
PHP

<?php
$sql = "SELECT " . PREFIX . "_Gutschriften.Jahr, " . PREFIX . "_Gutschriften.ID, " . PREFIX . "_Kontakte.Firma, " . PREFIX . "_Kontakte.Nachname, " . PREFIX . "_Kontakte.Vorname FROM " . PREFIX . "_Gutschriften LEFT JOIN " . PREFIX . "_Kontakte ON " . PREFIX . "_Gutschriften.Kontakt_ID = " . PREFIX . "_Kontakte.ID " . $Abfrage . " ORDER BY " . PREFIX . "_Gutschriften.Jahr DESC, " . PREFIX . "_Gutschriften.ID DESC;";
$result = $db->query($sql);
include __DIR__ . "/sv_overview.php";