/*存放帖子的表结构
create table announce (
announce_id int(11) not null auto_increment,
board_id smallint(6) not null,
title varchar(100) not null,
content tinytext,
add_time datetime default 0000-00-00 00:00:00 not null,
auth_name varchar(20) not null,
auth_mail varchar(40),
hit_count smallint(6) not null,
bytes mediumint(9) not null,
parent_id tinyint(4) not null,
auth_ip varchar(15) not null,
top_id int(11) not null,
return_count tinyint(4) not null,
face char(3) not null,
primary key (announce_id),
key board_id (board_id),
key top_id (top_id)
);
*/
function show_announce($id,$self_id){
global $dbconnect;
global $board_id;
$query="select * from announce where announce_id=$id";
$result=mysql_query($query,$dbconnect);
$myrow=mysql_fetch_array($result);
mysql_free_result($result);
echo "
\n";echo " ";
if($self_id!=$id)
echo "";
echo $myrow[title];
if($self_id!=$id)
echo "";
echo " – 【".$myrow[auth_name]."】 ".$myrow[add_time]." [id:$myrow][announce_id] 点击:$myrow[hit_count]] ($myrow[bytes] bytes) ($myrow[return_count])\n";
$query="select announce_id from announce where parent_id=$id order by announce_id desc";
$result=mysql_query($query,$dbconnect);
echo "
- \n";
while($myrow=mysql_fetch_array($result)){
show_announce($myrow[announce_id],$self_id);
}
echo "
\n";mysql_free_result($result);
echo "
";}
?>
论坛内容//此处需要连接数据库
//可以根据需要加入分页
$query="select announce_id from announce where top_id=0 order by announce_id desc ";
$result_top=mysql_query($query,$dbconnect);
echo "
- \n";
while($myrow_top=mysql_fetch_array($result_top)){
show_announce($myrow_top[announce_id],0);
}
echo "
\n";mysql_free_result($result_top);
?>