模仿OSO的论坛(二)

  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>