public static function get_list($_FORM) { $filter = reminder::get_list_filter($_FORM); if (is_array($filter) && count($filter)) { $f = " WHERE " . implode(" AND ", $filter); } $db = new db_alloc(); $q = "SELECT reminder.*,reminderRecipient.*,token.*,tokenAction.*, reminder.reminderID as rID\n FROM reminder\n LEFT JOIN reminderRecipient ON reminder.reminderID = reminderRecipient.reminderID\n LEFT JOIN token ON reminder.reminderHash = token.tokenHash\n LEFT JOIN tokenAction ON token.tokenActionID = tokenAction.tokenActionID\n " . $f . "\n GROUP BY reminder.reminderID\n ORDER BY reminderTime,reminderType"; $db->query($q); while ($row = $db->row()) { $reminder = new reminder(); $reminder->read_db_record($db); $rows[$row['reminderID']] = $row; } return $rows; }