<?php
/*存放帖子的表结构
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 "<li>\n";
echo "<img src='images/mood".$myrow[face].".gif'> ";
if($self_id!=$id)
echo "<a href='show.php3?board_id=$board_id&announce_id=$myrow[announce_id]&top_id=$myrow[top_id]'>";
echo $myrow[title];
if($self_id!=$id)
echo "</a>";
echo " - <strong>【".$myrow[auth_name]."】</strong>

[1] [2] 下一页

在google里搜索更多一个在PHP中利用递归实现论坛分级显示的例子

	Web www.51ec.org