Files
startup/inhalte/angebot_over.php

6 lines
469 B
PHP

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