read.php(用来显示相关主题内容)
<HTML><HEAD><TITLE>疑难问题</TITLE>
<LINK href="mypic/style.css" rel=STYLESHEET type=text/css></HEAD>
<BODY bgColor=#cccc99 bottomMargin=0 leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%" class=body_br >
<TBODY>
<TR>
<TD vAlign=top><BR>
<TABLE align=center border=0 cellPadding=3 cellSpacing=0 width=100%>
<TBODY>
<TD>主 题:<FONT class=mid
color=#993333><B>
<?php
include "connect.inc.php";
$query = "select * from guestbook where id=".$theme_id;
$res = mysql_query($query);
$row = mysql_fetch_array($res);
echo $row['theme'];
?>
</B></FONT></TD></tr><tr>
<TD align=middle vAlign=top width=100%><A
href="post.php"><IMG
border=0 src="mypic/post.gif"></A>
<A href="reply.php?theme_id=<?php echo $row['id'] ?>"><IMG
border=0
src="mypic/reply.gif"></A> <A
href="faq.php?page=1"><IMG
border=0
src="mypic/theme.gif"></A></TD></TR>
<?php
if ($row['answer_count']>5)
{echo "<TR> <TD>分 页:<FONT class=mid >";
for ($j=1;$j<=($row['answer_count']-1)/5+1;$j++) {
if ($j==$page) echo "<FONT color=#999999> [".$j."]</FONT> </A>";
else echo "<A href='read.php?theme_id=".$row['id']."&page=".$j."'[".$j."]</FONT> </A>";
}}
echo " 共有帖子".$row['answer_count']."个</TD>";
$this_id=$row['id'];
$query = "select id from guestbook where id<".$this_id." and type=1 order by id DESC";
$res = mysql_query($query);
$row = mysql_fetch_row($res);
$pre_id=$row[0];
$query = "select id from guestbook where id>".$this_id." and type=1 order by id";
$res = mysql_query($query);
$row = mysql_fetch_row($res);
$next_id=$row[0];
?>
</TR>
</TBODY></TABLE>
<TABLE align=center border=0 cellPadding=4 cellSpacing=2 width=100%>
<TBODY>
<TR>
<TD align=middle bgColor=#6f6f6f width="20%"><FONT color=#ffffff>作
者</FONT></TD>
<TD align=middle bgColor=#6f6f6f width="80%"><FONT color=#ffffff>内
容</FONT></TD></TR>
<?php
$query = "select * from guestbook where main_id=".$theme_id." or id=".$theme_id." order by time_open DESC limit ".strval(($page-1)*5).",5";
$res = mysql_query($query);
function TdBackColor() {
static $ColorStr;
if ($ColorStr=="#ededed") {
$ColorStr="#dedede";
} else {
$ColorStr="#ededed";
}
return($ColorStr);
}
for ($i=1;$i<=5;$i++)
{$row = @mysql_fetch_array($res);
if(!$row) break;
$ColorStr=TdBackColor();
echo "<TR>";
echo "<TD align=middle bgColor=".$ColorStr." vAlign=top width='20%'><FONT";
echo "class=mid><B>";
echo $row['name']."</B></FONT></TD>";
echo "<TD bgColor=".$ColorStr." vAlign=top width='80%'>";
echo "<TABLE border=0 cellPadding=0 cellSpacing=0 width='100%'>";
echo "<TBODY>";
echo "<TR>";
echo "<TD align=middle width=30><IMG align=ABSCENTER border=0";
echo " src='mypic/icon".$row['icon'].".gif'></TD>";
echo "<TD><FONT color=#336699>发表于: ".$row['time_open']."</FONT></TD>";
echo "<TD align=right></TD></TR>";
echo "<TR>";
echo "<TD colSpan=3>";
echo "<HR SIZE=1>";
echo "</TD></TR></TBODY></TABLE>".$row['content']."</TD></TR>";
echo "<TR>";
}
?>
<TR align=right bgColor=#6f6f6f>
<TD> </TD>
<TD><A
href="read.php?theme_id=<?php echo $pre_id?>&page=1"><FONT
color=#ffffff>上一个主题</FONT></A> <A
href="read.php?theme_id=<?php echo $next_id?>&page=1"><FONT
color=#ffffff>下一个主题</FONT></A> </TD></TR></TBODY></TABLE>
<HR SIZE=1 width=100%>
<BR></TD></TR>
</TBODY></TABLE>
</FORM>
</html>
<HTML><HEAD><TITLE>疑难问题</TITLE>
<LINK href="mypic/style.css" rel=STYLESHEET type=text/css></HEAD>
<BODY bgColor=#cccc99 bottomMargin=0 leftMargin=0 topMargin=0 marginwidth="0" marginheight="0">
<TABLE border=0 cellPadding=0 cellSpacing=0 width="100%" class=body_br >
<TBODY>
<TR>
<TD vAlign=top><BR>
<TABLE align=center border=0 cellPadding=3 cellSpacing=0 width=100%>
<TBODY>
<TD>主 题:<FONT class=mid
color=#993333><B>
<?php
include "connect.inc.php";
$query = "select * from guestbook where id=".$theme_id;
$res = mysql_query($query);
$row = mysql_fetch_array($res);
echo $row['theme'];
?>
</B></FONT></TD></tr><tr>
<TD align=middle vAlign=top width=100%><A
href="post.php"><IMG
border=0 src="mypic/post.gif"></A>
<A href="reply.php?theme_id=<?php echo $row['id'] ?>"><IMG
border=0
src="mypic/reply.gif"></A> <A
href="faq.php?page=1"><IMG
border=0
src="mypic/theme.gif"></A></TD></TR>
<?php
if ($row['answer_count']>5)
{echo "<TR> <TD>分 页:<FONT class=mid >";
for ($j=1;$j<=($row['answer_count']-1)/5+1;$j++) {
if ($j==$page) echo "<FONT color=#999999> [".$j."]</FONT> </A>";
else echo "<A href='read.php?theme_id=".$row['id']."&page=".$j."'[".$j."]</FONT> </A>";
}}
echo " 共有帖子".$row['answer_count']."个</TD>";
$this_id=$row['id'];
$query = "select id from guestbook where id<".$this_id." and type=1 order by id DESC";
$res = mysql_query($query);
$row = mysql_fetch_row($res);
$pre_id=$row[0];
$query = "select id from guestbook where id>".$this_id." and type=1 order by id";
$res = mysql_query($query);
$row = mysql_fetch_row($res);
$next_id=$row[0];
?>
</TR>
</TBODY></TABLE>
<TABLE align=center border=0 cellPadding=4 cellSpacing=2 width=100%>
<TBODY>
<TR>
<TD align=middle bgColor=#6f6f6f width="20%"><FONT color=#ffffff>作
者</FONT></TD>
<TD align=middle bgColor=#6f6f6f width="80%"><FONT color=#ffffff>内
容</FONT></TD></TR>
<?php
$query = "select * from guestbook where main_id=".$theme_id." or id=".$theme_id." order by time_open DESC limit ".strval(($page-1)*5).",5";
$res = mysql_query($query);
function TdBackColor() {
static $ColorStr;
if ($ColorStr=="#ededed") {
$ColorStr="#dedede";
} else {
$ColorStr="#ededed";
}
return($ColorStr);
}
for ($i=1;$i<=5;$i++)
{$row = @mysql_fetch_array($res);
if(!$row) break;
$ColorStr=TdBackColor();
echo "<TR>";
echo "<TD align=middle bgColor=".$ColorStr." vAlign=top width='20%'><FONT";
echo "class=mid><B>";
echo $row['name']."</B></FONT></TD>";
echo "<TD bgColor=".$ColorStr." vAlign=top width='80%'>";
echo "<TABLE border=0 cellPadding=0 cellSpacing=0 width='100%'>";
echo "<TBODY>";
echo "<TR>";
echo "<TD align=middle width=30><IMG align=ABSCENTER border=0";
echo " src='mypic/icon".$row['icon'].".gif'></TD>";
echo "<TD><FONT color=#336699>发表于: ".$row['time_open']."</FONT></TD>";
echo "<TD align=right></TD></TR>";
echo "<TR>";
echo "<TD colSpan=3>";
echo "<HR SIZE=1>";
echo "</TD></TR></TBODY></TABLE>".$row['content']."</TD></TR>";
echo "<TR>";
}
?>
<TR align=right bgColor=#6f6f6f>
<TD> </TD>
<TD><A
href="read.php?theme_id=<?php echo $pre_id?>&page=1"><FONT
color=#ffffff>上一个主题</FONT></A> <A
href="read.php?theme_id=<?php echo $next_id?>&page=1"><FONT
color=#ffffff>下一个主题</FONT></A> </TD></TR></TBODY></TABLE>
<HR SIZE=1 width=100%>
<BR></TD></TR>
</TBODY></TABLE>
</FORM>
</html>