NOW() AND NOT( activity LIKE 'ONLINE%' OR activity LIKE 'AFLYST%' OR activity LIKE 'UDSAT%' ) ORDER BY date LIMIT 1 ###############################################") AS $new_open); foreach(query(" ############################################### SELECT * FROM dates LEFT JOIN activities USING(activity) WHERE DATE(NOW()) <= date AND date <= DATE(DATE_ADD(NOW(),INTERVAL 10 MONTH)) ###############################################") AS $event) { // echo "

".end(array_keys($data))." - ".$event["activity"]."

\r\n"; if (count($data) < 2 || end(array_keys($data)) == $event["activity"]) { $data[$event["activity"]][] = $event; } else { break; } } //print_r($data); $result = array( "AlsLUG - Alssund Linux User Group", "www.alslug.dk", ); foreach(array_slice($data,0,2) AS $activity => $activities) { $string = $activity; foreach($activities AS $id => $event) $string .= " ".($id ? "og " : "").date("j/n",strtotime($event["date"])); $string .= " kl ".date("H:i",strtotime($event["start"])); $result[] = $string; } $result[] = "Vi holder lukket for fysiske møder indtil ".date("j. F ",strtotime($new_open["date"]))." på grund af corona"; $result[] = "Hold øje med www.alslug.dk"; echo "/topic ".join(" :: ",$result);