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>
|