diff options
| author | horus_arch | 2017-02-16 19:48:19 +0100 |
|---|---|---|
| committer | horus_arch | 2017-02-16 19:48:19 +0100 |
| commit | 21a8b55d990db40aafa8927cae89897e4522f90f (patch) | |
| tree | d03c78784f531c9b3fbbcd4956718db18d1dda03 | |
| parent | 655788feaad89defd596e4b0acd99d2e58ea29ac (diff) | |
| download | gospeladlershof.de-21a8b55d990db40aafa8927cae89897e4522f90f.tar.gz | |
SQL in CAPS.
| -rw-r--r-- | intern.gospeladlershof.de/code/termine.php | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/intern.gospeladlershof.de/code/termine.php b/intern.gospeladlershof.de/code/termine.php index 3f7aac5..751df5a 100644 --- a/intern.gospeladlershof.de/code/termine.php +++ b/intern.gospeladlershof.de/code/termine.php @@ -10,9 +10,9 @@ if ( false === $db ) { $_SESSION["error"] = "Kann keine Verbindung zur Datenbank herstellen."; } else { try { - $res = $db->query('select id, termin, uhrzeit from proben where date(STR_TO_DATE(termin, "%d.%m.%Y")) > (SELECT CURDATE() ) ORDER BY date(STR_TO_DATE(termin, "%d.%m.%Y"));'); + $res = $db->query('SELECT id, termin, uhrzeit FROM proben WHERE date(STR_TO_DATE(termin, "%d.%m.%Y")) > (SELECT CURDATE() ) ORDER BY date(STR_TO_DATE(termin, "%d.%m.%Y"));'); $proben = $res->fetchAll(PDO::FETCH_ASSOC); - $res = $db->query('select termin,uhrzeit,beschreibung,anfahrt from konzert order by id desc limit 1;'); + $res = $db->query('SELECT termin,uhrzeit,beschreibung,anfahrt FROM konzert ORDER BY id DESC LIMIT 1;'); $konzert = $res->fetchAll(PDO::FETCH_ASSOC); } catch( Exception $e ) { error_log($e->getMessage()); |