source: temp/test-xoops.ec-cube.net/html/test/kakinaka/topic_list.php @ 1044

<?php
include '../../mainfile.php';
include XOOPS_ROOT_PATH.'/modules/newbb/config.php';

global $arrResponse;

$sql = 'SELECT topic_id, topic_title, topic_response FROM ' . $xoopsDB->prefix('bb_topics') . ' ORDER BY topic_response, topic_id';

if ( !$result = $xoopsDB->query($sql) ) {
    redirect_header(XOOPS_URL.'/',1,_MD_ERROROCCURED);
    exit();
}


print '<table class="outer" cellspacing="1">
    <tr class="head" align="center">
        <td width="2%">&nbsp;</td>
        <td>&nbsp;<b><a href="<{$h_topic_link}>"><{$lang_topic}></a></b></td>
        <td width="7%" align="center" nowrap="nowrap"><b><a href="<{$h_reply_response}>"><{$lang_response}></a></b></td>
        <td width="5%" align="center" nowrap="nowrap"><b><a href="<{$h_reply_link}>"><{$lang_replies}></a></b></td>
        <td width="15%" align="center" nowrap="nowrap"><b><a href="<{$h_poster_link}>"><{$lang_poster}></a></b></td>
        <td width="8%" align="center" nowrap="nowrap"><b><a href="<{$h_views_link}>"><{$lang_views}></a></b></td>
        <td width="15%" align="center" nowrap="nowrap"><b><a href="<{$h_date_link}>"><{$lang_date}></a></b></td>
    </tr>';

while ( $myrow = $xoopsDB->fetchArray($result) ) {

    foreach($myrow as $key => $val){
        //$val = mb_convert_encoding($val, "euc-jp");
        if($key == "topic_response"){
            print($arrResponse[$val] . "\t");
        }else{
            print($val . "\t");
        }
    }
    print("<BR>");
}

print "</table>";

?>