|
$stop_num=8;
if($page_num==0){$start_num="0";
}else{
$start_num=$stop_num*($page_num-1);
}
$select_type=Fix_Backslash($select_type);
$select_type=Trim($select_type);
switch ($select_type)
{
case "":
$str_total="select present_id from present";
$SQLStr="select * from present order by present_date desc,star_num desc limit $start_num,$stop_num ";
//改由發表日期為排序//
//102/5/8只顯示2013年的文章 WHERE present_date > '2013-01-01 00:00:00'//
break;
default:
$str_total="select present_id from present where book_name like '%$select_type%' or book_author like '%$select_type%' or presenter like '%$select_type%' or present_contents like '%$select_type%' ";
$SQLStr="select * from present where book_name like '%$select_type%' or book_author like '%$select_type%' or presenter like '%$select_type%' or present_contents like '%$select_type%' order by star_num desc, present_date desc limit $start_num,$stop_num ";
}
$total=db_num($str_total);
$res=db_query($SQLStr);
$num=db_num($SQLStr);
?>
|
|
|
|
|
|
|
書名 |
作者 |
發表者 |
回覆 |
發表日期 |
|
|
|
|
|
|
|
|
|
|
|
|
if($num<1){?>
目前無任何資料!! |
|
|
|
|
|
}else{
for($i=0;$i<$num;$i++){
$row=db_fetch_array($res);
?>
|
|
|
** |
$present_id=$row['present_id'];
$SQLStr_r="select * from reply where present_id='$present_id' ";
echo $num_r=db_num($SQLStr_r);
?>
|
|
|
|
|
|
|
|
}}?>
|
|
|
|
|
|
|
require "page.php";?>
|
|