社区(php&&mysql)四

　　 
　　echo "<br>";
    echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'>";
      echo "<tr><td>";

      echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white class='tablefont'>";
        echo "<tr bgcolor=#F1E1FF>";
            echo "<th >夹肈</th>";
            echo "<th>祇癬?</th>";
            echo "<th width=30>?莱</th>";
            echo "<th width=30>??</th>";
            echo "<th width=70>ら戳</th>";
        echo "</tr>";
        $qsql="SELECT * from bbs_subj where id='$sid' ";
        $rs=mysql_db_query($sql['db'],$qsql);
        $row=mysql_fetch_array($rs);
            $id=$row['id'];
            $banner=$row['banner'];
            $poster=$row['poster'];
            $views=$row['views'];
            $wdate=sdatetime($row['wdate']);
            $docs=reAnum($id);
            echo "<tr bgcolor='#F0F8FF'>";
                echo "<td>";
                    if($sid!=$rid) {
                    echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>";
                    echo $banner;
                    echo "</a>";
                    } else echo "<font color=red><b>$banner</B></font>";
                echo "</td>";
                echo "<td>";
                    echo $poster;
                echo "</td>";
                echo "<td class='num'>";
                    echo $docs;
                echo "</td>";
                echo "<td class='num'>";
                    echo $views;
                echo "</td>";
                echo "<td class='num'>";
                    echo $wdate;
                echo "</td>";
            echo "</tr>";
        $qsql="SELECT * from bbs_docs where sid='$sid' order by wdate";
        $rs=mysql_db_query($sql['db'],$qsql);     
        while($row=mysql_fetch_array($rs)) {
             
            $id=$row['id'];
            $banner=$row['banner'];
            $poster=$row['poster'];
            $views=$row['views'];
            $wdate=sdatetime($row['wdate']);
            $docs=reAnum($id);
            echo "<tr bgcolor='#F0F0F0'>";
                echo "<td>";
                    if($sid!=$rid && $rid==$id) {
                        echo "<font color=red><b>&nbsp;&nbsp;$banner</B></font>";
                    } else {
                        echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
                        echo "&nbsp;&nbsp;$banner";
                        echo "</a>";
                    }
                echo "</td>";
                echo "<td>";
                    echo $poster;
                echo "</td>";
                echo "<td class='num'>";
                    echo "&nbsp;";
                echo "</td>";
                echo "<td class='num'>";
                    echo $views;
                echo "</td>";
                echo "<td class='num'>";
                    echo $wdate;
                echo "</td>";
            echo "</tr>";
             
        }
      echo "</td></tr></table>";
    echo"</td></tr></table>";
  } // ====
     
    echo "<a name='re'></a>";
    if($type==1) {
        if(substr($rebanner,0,3)!="Re:")
            $rbanner="Re:".$rebanner;
        else $rbanner=$rebanner;
    }     
    echo "<FORM  name=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=post2>";
    echo "<input type='hidden' name=aid value='$aid'>";
    echo "<input type='hidden' name=sid value='$sid'>";
    echo "<input type='hidden' name=type value='$type'>";
    echo "<TABLE width=95% BORDER=0  align=center cellPadding=3 cellSpacing=0 class='tablefont'>";
        if($sid) {
            echo "<TR bgcolor='white'>";
            echo "<TH colspan=2 >";
                echo "??癚阶硂?杠肈";
            echo "</TH>";
             
            echo "</TR>";
        }
         
        echo "<TR>";
            echo "<TD width=100 align=right>";
                echo "?肈:";
            echo "</TD>";
            echo "<TD>";
                echo "<INPUT TYPE='text' NAME='banner' size=60 value='$rbanner'>";
            echo "</TD>";
        echo "</TR>";
        echo "<TR>";
            echo "<TD width=100 align=right>";
                echo "祇ē?:";
            echo "</TD>";
            echo "<TD>";
                echo "<INPUT TYPE='text' NAME='poster' size=30 value='$c_poster'>";
                 
            echo "</TD>";
        echo "</TR>";
        echo "<TR>";
            echo "<TD width=100 align=right>";
                echo "E-Mail:";

            echo "</TD>";
            echo "<TD>";
                echo "<INPUT TYPE='text' NAME='email' size=30 value='$c_email'>";
                                 
            echo "</TD>";
        echo "</TR>";
        echo "<TR>";
            echo "<TD width=100 align=right valign=top>";
                echo "ず甧:";
            echo "</TD>";
            echo "<TD>";
                echo "<font color=green>や穿禬硈挡ノ猭絛ㄒ:<font color=red><b>[www]http://www.jerry.com.tw[/www]</b></font></font><br>";
                echo "<TEXTAREA NAME='body' cols='80' rows='16'>";
                echo "</TEXTAREA>";
            echo "</TD>";
        echo "</TR>";
        echo "<TR>";
            echo "<TD align=center colspan=2>";
                //echo "<INPUT TYPE='checkbox' NAME='remail'>";
                //echo "?滦???";
                if($sid) {
                    $br="-----------------------------------------------------------";
                    $obody="まノ $poster ?ゅ彻n$brn".$body;
                    $obody.="n$brn?滦癚阶?ず甧??:n";
                    echo "<input type='hidden' name=obody value="$obody">";
                    echo "<INPUT TYPE='button' value='まノ?ゅ' onClick="this.form.body.value=this.form.body.value + this.form.obody.value; this.form.obody.value='';">";
                }
                 
                echo "&nbsp;&nbsp;&nbsp;&nbsp;<INPUT TYPE='submit' value='癳?'>";
            echo "</TD>";
        echo "</TR>";
    echo "</TABLE>";
     
}
待续....... 

原文转自：http://www.ltesting.net