//此頁面為php3.php
include "signup/MySQL.inc";
switch($part){
case "1" :$table="bbs_php";break;
case "2" :$table="bbs_mysql";break;
case "3" :$table="bbs_html";break;
case "4" :$table="bbs_js";
}
//echo $part;
?>
xiaoyang
人氣
|
文章題目
|
作者
|
日期
|
$sql="select * from ".$table." order by row DESC"; $result=mysql_query($sql)or die(mysql_error()); $row1=mysql_num_rows($result); $row_max_page=12; //分頁計算 $page=ceil($row1/$row_max_page); $left_row=$row1-$p*$row_max_page; $PRe_left_row=$left_row+12; $start_row=$left_row+$row_max_page+1; if($left_row<=0) { $start_row=$pre_left_row+1; $left_row=0; } $sql="select * from ".$table." where row<'$start_row' and row>'$left_row' order by row DESC"; $result=mysql_query($sql)or die(mysql_error()); while($row=mysql_fetch_array($result)){ static $i=0; $i++; if($i%2) $color="CCCCFF"; else $color="FFCCFF"; echo "
"; echo "
";
echo " ".$row["number"]."";
echo " | "; echo "
";
echo " ".$row["title"]."";
echo " | "; echo "
";
echo " ".$row["userid"]."";
echo " | "; echo "
";
echo " ".$row["date1"]."";
echo " |
"; } echo"
";
echo "
";
for($i=1;$i<=$page;$i++)
{
echo "[".$i."] ";
}
?>
|
" target="_self" onMouSEOver="window.status='';return true">我要發言
