Example #1
0
    if ($i <= _RESEARCH_COL) {
        if ($count == 0) {
            echo "<TR>";
        }
        //ª×èÍËÁÇ´ËÁÙè
        $res['category'] = $db->select_query("SELECT category_name FROM " . TB_RESEARCH_CAT . " WHERE id='" . $arr['research']['category'] . "' ");
        $arr['category'] = $db->fetch($res['category']);
        $researchid = $arr['research']['id'];
        $ress['com'] = $db->select_query("SELECT *,count(id) as com FROM " . TB_RESEARCH_COMMENT . " WHERE id ='" . $researchid . "' group by id");
        $arrs['com'] = $db->fetch($ress['com']);
        ?>
			<TD width="50%" valign=top align="left" valign="top">	
				<TABLE width="100%" align="left">
				<TR>
				<TD class="timemini"><font size="4"><b><?php 
        echo ThaiTimeMini($arr['research']['post_date'], "");
        ?>
</b></font></td>
				<td ><?php 
        echo _RESEARCH_AUTH;
        ?>
 <FONT COLOR="#990000"><B><?php 
        echo $arr['research']['auth'];
        ?>
</font><br><font color=#C3C3C3> 
					<?php 
        echo ThaiTimeConvert($arr['research']['post_date'], "", "");
        ?>
 </font></td></tr>
					<tr><td colspan="2"><?php 
        $rater_ids = $arr['research']['id'];
Example #2
0
        if ($count == 0) {
            echo "<TR>";
        }
        $content = $arr['knowledge']['headline'];
        $Detail = stripslashes(FixQuotes($content));
        $res['category'] = $db->select_query("SELECT * FROM " . TB_KNOWLEDGE_CAT . " WHERE id='" . $arr['knowledge']['category'] . "' ");
        $arr['category'] = $db->fetch($res['category']);
        $knowledgeid = $arr['knowledge']['id'];
        $ress['com'] = $db->select_query("SELECT *,count(knowledge_id) as com FROM " . TB_KNOWLEDGE_COMMENT . " WHERE knowledge_id ='" . $knowledgeid . "' group by knowledge_id");
        $arrs['com'] = $db->fetch($ress['com']);
        ?>
			<TD width="50%" valign=top align="left">	
				<TABLE width="100%" border=0 cellSpacing=0 cellPadding=0>
				<TR>
					<TD class="timemini"><font size="4"><b><?php 
        echo ThaiTimeMini($arr['knowledge']['post_date'], "");
        ?>
</b></font></td>
					<td ><?php 
        echo _BLOG_AUTH;
        ?>
 <FONT COLOR="#990000"><B><?php 
        echo $arr['knowledge']['posted'];
        ?>
</font><br><font color=#C3C3C3> 
					<?php 
        echo ThaiTimeConvert($arr['knowledge']['post_date'], "", "");
        ?>
 </font>  <a href="createpdf.php?mo=knowledge&id=<?php 
        echo $arr['knowledge']['id'];
        ?>
Example #3
0
            echo "<TR>";
        }
        $content = $arr['news']['headline'];
        $Detail = stripslashes(FixQuotes($content));
        $res['category'] = $db->select_query("SELECT * FROM " . TB_NEWS_CAT . " WHERE id='" . $arr['news']['category'] . "' ");
        $arr['category'] = $db->fetch($res['category']);
        $newsid = $arr['news']['id'];
        $ress['com'] = $db->select_query("SELECT *,count(news_id) as com FROM " . TB_NEWS_COMMENT . " WHERE news_id ='" . $newsid . "' group by news_id");
        $arrs['com'] = $db->fetch($ress['com']);
        ?>
													<TD width="50%" valign=top align="left">	

															<TABLE width="100%" border=0 cellSpacing=0 cellPadding=0>
															<TR>
															<TD class="timemini"><font size="4"><b><?php 
        echo ThaiTimeMini($arr['news']['post_date'], "");
        ?>
</b></font></td>
															<td ><?php 
        echo _BLOG_AUTH;
        ?>
 <FONT COLOR="#990000"><B><?php 
        echo $arr['news']['posted'];
        ?>
</font><br><font color=#C3C3C3> 
					<?php 
        echo ThaiTimeConvert($arr['news']['post_date'], "", "");
        ?>
 </font>  <a href="createpdf.php?mo=news&id=<?php 
        echo $arr['news']['id'];
        ?>