summaryrefslogtreecommitdiffstats
path: root/application/models/EventcategoryMapper.php
diff options
context:
space:
mode:
Diffstat (limited to 'application/models/EventcategoryMapper.php')
-rwxr-xr-xapplication/models/EventcategoryMapper.php9
1 files changed, 6 insertions, 3 deletions
diff --git a/application/models/EventcategoryMapper.php b/application/models/EventcategoryMapper.php
index 5298af1..f481140 100755
--- a/application/models/EventcategoryMapper.php
+++ b/application/models/EventcategoryMapper.php
@@ -161,12 +161,15 @@ class Application_Model_EventcategoryMapper
->from(array('pcec' => 'poolctrl_eventcategory'),
array('color' => 'pcec.color'))
->join(array('pce' => 'poolctrl_event'),
- 'pce.category = pcec.eventcategoryID')
+ 'pce.category = pcec.eventcategoryID',
+ array())
->where('pce.pbs_poolID = ?', $poolID)
- ->group('pce.category');
+ ->group('pce.category')
+ ->order('eventcategoryID ASC')
+ ;
$stmt = $db->query($select);
- $result = $stmt->fetchAll(PDO::FETCH_NUM);
+ $result = $stmt->fetchAll(PDO::FETCH_COLUMN, 0);
return $result;
}