1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75

<?php
function showTop($dbnames,$showTop)
{
    $chk_date = date("j M Y",mktime( date("H")+$p_hour, date("i")+$p_min ));
    //mysql_connect($host,$user,$passwd);
    // Query ข้อมูลตามจำนวนที่กำหนด
    $sql = "select * from cms_webboard_data order by No DESC limit 0,$showTop";
    $result = mysql_query($sql) or die("Faied SQL Query");
    $NRow = mysql_num_rows($result);
    if($NRow==0) { 
        echo "<br><center>ยังไม่มีคำถาม</center>";
    }
    // แสดงหัวข้อของบอร์ด
    else {
    echo"<table width='100%' border='0' align='center' cellpadding='1' cellspacing='1' bgcolor='#0394e9'>";

    // วนลูปแสดงข้อมูลที่อ่านได้
    $count=0;
        while ($row = mysql_fetch_array($result)) {
            $count++;
            // กำหนดค่าตัวแปร
            $No = sprintf("%05d",$row["No"]);
            $Question = $row["Question"];
            if(strlen($Question)>100) {
                // จำกัดความยาวของกระทู้ที่ 80 ตัวอักษร
                $Question = substr($Question,0,100)."...";
            }
            $Name = $row["Name"];
            $Member = $row["Member"];
            $Date = trim(substr($row["Date"],0,60)); // แสดงเฉพาะวันที่
            $Reply = $row["Reply"];
            $ReplyDate = substr($row["ReplyDate"],0,60); // แสดงเฉพาะวันที่
            if($count%2==0)
                echo "<tr height='25' bgcolor='dddddd'><td width=80 valign = 'top' align = 'left'>";
            else
                echo "<tr height='25' bgcolor='eeeeee'><td width=80 valign = 'top' align = 'left'>";
            // แสดงรูป folder
            if($ReplyDate!="") {
                echo "<img src='coremain/module/webboard/img/openfd.gif'> &nbsp;&nbsp;";
            }
            else {
                if($Date==$chk_date) {
                    echo "<img src='coremain/module/webboard/img/newfd.gif'>&nbsp;&nbsp;";
                } 
                else {
                    echo"<img src='coremain/module/webboard/img/closefd.gif'>&nbsp;&nbsp; ";
                }
            }
            echo "$No</td><td>";
            ?>
            <a href="#WIN" onClick="window.open('coremain/module/webboard/show.php?No=<?echo $row[No]?>&web_name=<?echo $_SESSION[web_name]?>&name_post=<?echo $_SESSION[name_post]?>','blah20','width=770,height=450,location=no,menubar=no,toolbar=no,scrollbars=yes,resizable=yes')"><?echo $data[name_th]?>
            <?
                echo check_word_sencor($Question)."</a>";        
                

            if($Member) {
                echo "&nbsp;&nbsp;$Name<img src='coremain/module/webboard/img/member.gif'>[$Date]";
            }
            else {
                echo "&nbsp;&nbsp;$Name&nbsp; [$Date]";
            }
            
            // ตรวจสอบว่ามีคนตอบคำถามหรือยัง
            if($ReplyDate!="") {
                echo "<B>&nbsp;&nbsp;(<FONT COLOR=#FF0000 class='Menu'>$Reply</font>)</B>";
            }
            else {
                echo "&nbsp;&nbsp;<B>(</B>$Reply<B>)</B>";
            }
            echo "</td></tr>";
        }
        echo "</table>";
    }
}
?>