Ignore:
Timestamp:
2006/12/11 22:40:09 (20 years ago)
Author:
uehara
Message:
 
File:
1 edited

Legend:

Unmodified
Added
Removed

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

    r722 r727  
    120120 
    121121    // public static 
     122    function &getAllCommentByOptionId($option_id) 
     123    { 
     124        $db =& Database::getInstance(); 
     125        $ret = array(); 
     126        $sql = "SELECT u.uid, u.uname, l.rating_id, l.comment FROM ".$db->prefix("xoopspoll_log")." l, ". $db->prefix("users") ." u WHERE l.user_id = u.uid AND l.option_id=".intval($option_id)." ORDER BY time DESC"; 
     127        $result = $db->query($sql); 
     128        while ( $myrow = $db->fetchArray($result) ) { 
     129            $ret[] = new XoopsPollOption($myrow); 
     130        } 
     131        //echo $sql; 
     132        return $ret; 
     133    } 
     134     
     135     
     136    // public static 
    122137    function &getOptionByOptionId($option_id) 
    123138    { 
Note: See TracChangeset for help on using the changeset viewer.