Changeset 10313 for temp/trunk/html/admin/contents/recommend_search.php

Timestamp:

2006/12/06 13:03:31 (20 years ago)

Author:

kaki

Message:

 

File:

• temp/trunk/html/admin/contents/recommend_search.php (modified) (1 diff)

temp/trunk/html/admin/contents/recommend_search.php

@@ -89 +89 @@
         $page_max = SEARCH_PMAX;
     }
-    
+
     // ¥Ú¡¼¥¸Á÷¤ê¤Î¼èÆÀ
     $objNavi = new SC_PageNavi($_POST['search_pageno'], $linemax, $page_max, "fnNaviSearchOnlyPage", NAVI_PMAX);
     $objPage->tpl_strnavi = $objNavi->strnavi;      // ɽ¼¨Ê¸»úÎó
     $startno = $objNavi->start_row;
-    
+
     // ¼èÆÀÈϰϤλØÄê(³«»Ï¹ÔÈֹ桢¹Ô¿ô¤Î¥»¥Ã¥È)
-    $objQuery->setlimitoffset($page_max, $startno);
-
+    if(DB_TYPE != "mysql") $objQuery->setlimitoffset($page_max, $startno);
     // ɽ¼¨½ç½ø
     $objQuery->setorder($order);
+
+    // view¤â¹Ê¹þ¤ß¤ò¤«¤±¤ë(mysqlÍÑ)
+    sfViewWhere("&&noncls_where&&", $where, $arrval, $objQuery->order . " " .  $objQuery->setlimitoffset($page_max, $startno, true));
+
     // ¸¡º÷·ë²Ì¤Î¼èÆÀ
     $objPage->arrProducts = $objQuery->select($col, $from, $where, $arrval);