Changeset 812 for temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspolloption.php

Timestamp:

2006/12/13 10:01:48 (19 years ago)

Author:

uehara

Message:

 

File:

• temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspolloption.php (modified) (1 diff)

temp/test-xoops.ec-cube.net/html/modules/xoopspoll/class/xoopspolloption.php

@@ -155 +155 @@
         
     // public static
-    function &getAllOption()
+    function &getAllOption($limit_start, $limit_end)
     {
         $db =& Database::getInstance();
         $ret = array();
-        $sql = "SELECT * FROM ".$db->prefix("xoopspoll_option") . " ORDER BY update_date DESC";
+        $sql = "SELECT * FROM ".$db->prefix("xoopspoll_option") . " ORDER BY update_date DESC LIMIT $limit_start, $limit_end";
         $result = $db->query($sql);
         while ( $myrow = $db->fetchArray($result) ) {
             $ret[] = $myrow;
         }
+        $sql = "SELECT count(*) as count FROM ".$db->prefix("xoopspoll_option") . " ORDER BY update_date DESC";
+        $result = $db->query($sql);
+        $myrow = $db->fetchArray($result);
+        
+        $ret['count'] = $myrow['count'];
         //echo $sql;
         return $ret;