Changeset 827 for temp/test-xoops.ec-cube.net/html/modules

Timestamp:

2006/12/13 10:34:52 (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

@@ -135 +135 @@
             $ret[] = $myrow;
         }
+        $sql = "SELECT count(*) as count FROM ".$db->prefix("xoopspoll_log")." l LEFT JOIN ". $db->prefix("users") ." u  ON l.user_id = u.uid WHERE l.option_id=".intval($option_id)." ORDER BY time DESC  LIMIT $limit_start, $limit_end";
+        $result = $db->query($sql);
+        $myrow = $db->fetchArray($result);
+        
+        $ret['count'] = $myrow['count'];
+        
         //echo $sql;
         return $ret;