Viewing file: show10.php (4.86 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
บอร์ด 10 อันดับล่าสุด
function showTop($Category,$showTop) {
include("config.inc.php");
include("function.php");
//$chk_date = date("Y-m-d");
$chk_date = substr(date("Y-m-d H:i:s"),-19,-9);
mysql_connect($host,$user,$passwd);
mysql_query("SET NAMES 'tis620'");
// Query ข้อมูลตามจำนวนที่กำหนด
$sql = "select * from webboard_data where Category='$Category' order by No DESC limit 0,$showTop";
$result = mysql_db_query($dbname,$sql) or die("Faied SQL Query");
$NRow = mysql_num_rows($result);
if($NRow==0) {
echo "ยังไม่มีคำถาม
\n";
}
// แสดงหัวข้อของบอร์ด
else {
echo " \n";
// วนลูปแสดงข้อมูลที่อ่านได้
while ($row = mysql_fetch_array($result)) {
// กำหนดค่าตัวแปร
$No = sprintf("%05d",$row["No"]);
$Question = $row["Question"];
if(strlen($Question)>45) {
// จำกัดความยาวของกระทู้ที่ 45 ตัวอักษร
$Question = substr($Question,0,45)."...";
}
$Name = $row["Name"];
$Member = $row["Member"];
//$Date = trim(substr($row["Date"],0,11)); // แสดงเฉพาะวันที่
$ckDate = trim(substr($row["Date"],-19,-9)); // แสดงเฉพาะวันที่
$Date = convert_date($row["Date"]);
$Reply = $row["Reply"];
$pageviewdata = $row["pageview"];
$ckReplyDate = trim(substr($row["ReplyDate"],-19,-9));
$ReplyDate = convert_date($row["ReplyDate"]);
echo "\n";
// แสดงรูป folder
if($Reply>="10" )
{
echo "\t \n";
}
elseif($ckReplyDate!="")
{
echo "\t \n";
}
elseif($Date==$chk_date)
{
echo "\t \n";
}
else {
echo "\t \n";
}
if(($ckReplyDate==$chk_date)&&($nphoto!='')&&($ckDate==$chk_date)){
echo "\t$Question ![](../webboard/pic/cam.gif) \n";
}
elseif(($ckReplyDate==$chk_date)&&($nphoto!='')) {
echo "\t$Question \n";
}
elseif(($ckReplyDate==$chk_date) &&($ckDate==$chk_date))
{echo "\t$Question \n";
}
elseif($ckReplyDate==$chk_date)
{echo "\t$Question \n";
}
elseif(($nphoto!='') &&($ckDate==$chk_date))
{echo "\t$Question \n";
}
elseif($nphoto!='')
{echo "\t$Question \n";
}
elseif($ckDate==$chk_date)
{echo "\t$Question \n";
}
else{
echo "\t$Question\n";
}
if($Member) {
echo "\t $Name [$Date] \n";
}
else {
echo "\t$Name [$Date]\n";
}
// ตรวจสอบว่ามีคนตอบคำถามหรือยัง
if($ckReplyDate!="") {
echo "\t($Reply/$pageviewdata) \n";
}
else {
echo "\t($Reply/$pageviewdata) ";
}
echo "\n | \n\n";
}
echo " \n\n ";
}
mysql_close();
}
?>
|