diff options
| author | Hannes "Brolaugh" Kindströmmer <me@brolaugh.com> | 2016-03-17 00:18:16 +0100 |
|---|---|---|
| committer | Hannes "Brolaugh" Kindströmmer <me@brolaugh.com> | 2016-03-17 00:18:16 +0100 |
| commit | ca8212a1182d6f332347d43b86948be2897f0964 (patch) | |
| tree | c8ad1e0880bb025f0869bebd00fa981a63e234ea | |
| parent | 85776d3e149ee4cd5c98c960468500ad06e6f046 (diff) | |
| download | tasklist-php-ca8212a1182d6f332347d43b86948be2897f0964.zip tasklist-php-ca8212a1182d6f332347d43b86948be2897f0964.tar.gz tasklist-php-ca8212a1182d6f332347d43b86948be2897f0964.tar.bz2 | |
Removed "ORDER BY..." in getTasksWithFollowingStatus() it caused error
| -rw-r--r-- | App/database/Select.php | 5 |
1 files changed, 2 insertions, 3 deletions
diff --git a/App/database/Select.php b/App/database/Select.php index 0c0c5f2..fed1362 100644 --- a/App/database/Select.php +++ b/App/database/Select.php @@ -57,9 +57,8 @@ class Select extends dbSetup /** * @param int array $taskID */ - public function getTasksWithFollowingStatus($taskID=array(1)) - { - $query = "SELECT task_with_status.id as id, title, description, user, level, stamp, task_with_status.style_class as style_class, status_level.id as level_id FROM `task_with_status` LEFT JOIN status_level ON task_with_status.level=status_level.plain_text ORDER BY stamp DESC"; + public function getTasksWithFollowingStatus($taskID=array(1)){ + $query = "SELECT task_with_status.id as id, title, description, user, level, stamp, task_with_status.style_class as style_class, status_level.id as level_id FROM `task_with_status` LEFT JOIN status_level ON task_with_status.level=status_level.plain_text"; $param = ""; $secondParam = $taskID; if (count($taskID) > 0) { |