Changeset 4791 for temp/trunk/data/lib

Timestamp:

2006/09/15 13:16:49 (20 years ago)

Author:

kakinaka

Message:

blank

File:

• temp/trunk/data/lib/slib.php (modified) (2 diffs)

temp/trunk/data/lib/slib.php

@@ -1052 +1052 @@
 /* µ¬³ÊʬÎà¤Î·ï¿ô¼èÆÀ */
 function sfGetClassCatCount() {
-    $sql = "select count(dtb_class.class_id), dtb_class.class_id ";
+    $sql = "select count(dtb_class.class_id) as count, dtb_class.class_id ";
     $sql.= "from dtb_class inner join dtb_classcategory on dtb_class.class_id = dtb_classcategory.class_id ";
     $sql.= "where dtb_class.del_flg = 0 AND dtb_classcategory.del_flg = 0 ";
@@ -1058 +1058 @@
     $objQuery = new SC_Query();
     $arrList = $objQuery->getall($sql);
-    $objQuery->getlastquery();
     // ¥­¡¼¤ÈÃͤò¥»¥Ã¥È¤·¤¿ÇÛÎó¤ò¼èÆÀ
     $arrRet = sfArrKeyValue($arrList, 'class_id', 'count');
-    
-    sfprintr($arrRet);
     
     return $arrRet;