if ($_POST) {
$html = nl2br(htmlspecialchars($_POST['body']));
$html = empty($html) ? NULL : "<p>$html</p>";
- $query = $Db->insert('issues', [
+ $query = $Db->set('issues', [
'page' => $Page,
'subject' => $_POST['subject'],
'body' => $html,
$_POST = [];
}
-$query = $Db->query('SELECT * FROM issues ORDER BY updated DESC');
+$sql = 'SELECT * FROM issues';
+if (isset($_GET['open'])) {
+ $sql .= ' WHERE closed IS NULL';
+}
+$sql .= ' ORDER BY closed IS NOT NULL, updated DESC';
+$query = $Db->query($sql);
ob_start();
print '<ul>';