Changeset 4272 for OpenPNE/trunk/webapp/lib/db/review.php

Timestamp:

Oct 3, 2007, 8:02:58 PM (13 years ago)

Author:

ogawa

Message:

#1348:MySQL4.0以前の環境で管理画面のメンバーリストに誰も表示されない

File:

• OpenPNE/trunk/webapp/lib/db/review.php (modified) (1 diff)

OpenPNE/trunk/webapp/lib/db/review.php

@@ -162 +162 @@
     $from = " FROM c_review INNER JOIN c_review_comment USING (c_review_id)";
 
-    $where = ' WHERE true';
+    $wheres = array();
     $params = array();
     if ($keyword) {
-        $where .= ' AND c_review.title LIKE ?';
+        $wheres[] = 'c_review.title LIKE ?';
         $params[] = '%'.check_search_word($keyword).'%';
     }
     if ($category_id) {
-        $where .= ' AND c_review.c_review_category_id = ?';
+        $wheres[] = 'c_review.c_review_category_id = ?';
         $params[] = intval($category_id);
+    }
+    if ($wheres) {
+        $where = ' WHERE ' . implode(' AND ', $wheres);
+    } else {
+        $where = '';
     }