From f70f746b5951e29eef449f962d5f531ed4a5961f Mon Sep 17 00:00:00 2001 From: Horus Date: Tue, 27 Sep 2016 20:01:40 +0200 Subject: Sortiert jetzt richtig (Bugfix!) + HTML () wird wieder zu Markdown für Hugo. --- intern/api/termine.php | 4 +++- 1 file changed, 3 insertions(+), 1 deletion(-) diff --git a/intern/api/termine.php b/intern/api/termine.php index 97059a8..3b0658d 100644 --- a/intern/api/termine.php +++ b/intern/api/termine.php @@ -11,11 +11,13 @@ if ( false === $db ) { exit; } -$res = $db->query('select termin, uhrzeit from proben where date(STR_TO_DATE(termin, "%d.%m.%Y")) > (SELECT CURDATE() );'); +$res = $db->query('select 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;'); $konzert = $res->fetchAll(PDO::FETCH_ASSOC); +$konzert[0]["beschreibung"] = str_replace("", "**", str_replace("", "**", $konzert[0]["beschreibung"])); + #$output = array("konzert" => $konzert, "proben" => $proben, "build" => date("d.m.Y H:i:s")); $output = array("konzert" => $konzert, "proben" => $proben, "build" => date("Y-m-d H:i:s")); $data = json_encode($output, JSON_PRETTY_PRINT); -- cgit v1.2.3