最近做了个论坛,不知道怎么弄的?只显示主题数,不显示其他,大家给看一下下面的代码啊.代码是长了点,但是为了让大家看清楚,就全贴出来了。下面的是论坛显示程序:f_post.php
<?php
$connid=@mysql_connect("localhost","root","myoa888");
?>
显示论坛信息
<?php
$query="select * from board where id='$type'";
$result=mysql_db_query("forum",$query);
$fname=mysql_result($result,0,"name");
$fadmin=mysql_result($result,0,"admin");
$fadmin2=mysql_result($result,0,"admin2");
$fadmin3=mysql_result($result,0,"admin3");
$sql="select id from article where type='$type'";
$result=mysql_db_query("forum",$sql);
$fxnum=mysql_num_rows($result);
if($user_cookie != "")
{
$cookie=1;
if($$user_cookie==$fadmin)
{
$f_admin=1;
}
if($$user_cookie==$fadmin2)
{
$f_admin=1;
}
if($$user_cookie==$fadmin3)
{
$f_admin=1;
}
}
?>
<?php
echo $fname;
echo " ($fxnum)";
echo"
斑竹:";
if( $fadmin == "")
{
echo"程政斑竹中。。。";
}
else
{
echo"
$fadmin ";
}
if( $fadmin2!="")
{
echo"$fadmin2 ";
}
if($fadmin3!="")
{
echo "$fadmin3 ";
}
echo"";
?>
<?php
if ($cookie == 1)
{
echo"发表文章 ";
}
else
{
echo "您还未登陆，只有登陆以后才能发表文章";
}
?>
<?php
if($offset != 0)
{
$preoffset=$offset-20;
echo"
前一页 \n";
}
if(($offset+20)<$fnum)
{
$newoffset=$offset+20;
echo"
后一页 \n";
}
mysql_free_result($result);
?>
<?php
$sql="select * from article where type='$type'
and replyx = 0 order by newdate desc limit $offset,20";
$result=mysql_db_query("forum",$sql);
$num=mysql_num_rows($result);
if($num != 0)
{
while($r=mysql_fetch_array($result))
{
$fid=$r["id"];
$ftitle=$r["title"];
$fwriter=$r["writer"];
$fdate=$r["newdate"];
$fm=$r["mark"];
$frenum=$r["renum"];
$sql="select id from article where reply='$fid'";
$result=mysql_db_query("forum",$sql);
$ffnum=mysql_num_rows($result);
echo"| ";
echo"$ffnum | \n";
echo "";
echo "";
echo "$ftitle | \n";
echo "";
if($fm == 1)
{
echo "m ";
}
echo $frenum;
echo " | \n";
echo "";
echo "
$fwriter | \n";
echo "";
echo "$fdate |
\n";
}
}
?>
<?php
if($cookie == 1)
{
echo "发表文章 ";
}
else
{
echo"您还为登陆只有登陆后才能发表文章";
}
?>
<?php
if($offset != 0)
{
$preoffset=$offset-20;
if($preoffset<0)
{
$preoffset=0;
}
echo "
前一夜 \n";
}
if(($offset + 20)<$fnum)
{
$newoffset=$offset+20;
echo "
后一夜 \n";
}
mysql_free_result($result);
?>
订阅该问题
悬赏分：20 - 2007年08月21日