BBS(php & mysql)完整版(三)

<?

$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 "<tr>";    
echo "  <td width=10% bgcolor=#".$color."> ";   
echo "    <div align=center><font size=2 color=#3333FF>".$row["number"]."</font></div>";   
echo "  </td>";   
echo "  <td width=38% bgcolor=#".$color."> ";   
echo "    <div align=center><font size=2 color=#3333FF><a    href='look.php?id=".$row["id"]."&&table;=".$table."'>".$row["title"]."</a></font></div>";   
echo "  </td>";   
echo "  <td width=26% bgcolor=#".$color."> ";   
echo "    <div align=center><font size=2 color=#3333FF>".$row["userid"]."</font></div>";   
echo "  </td>";   
echo "  <td width=26% bgcolor=#".$color."> ";   
echo "    <div align=center><font size=2 color=#3333FF>".$row["date1"]."</font></div>";   
echo "  </td>    </tr>";   

     }   

echo"</table>";                  
echo "<BR><div align=center><table><tr><td><FONT SIZE=2 >";   

for($i=1;$i<=$page;$i++)
{
echo "[".$i."] ";
}
?>