fetch_assoc_one($sql); if(!$bbsusers["id"]) //检查用户名 { ?> 没有您所要搜索的用户,请稍等……
主题 作者 回复 人气 最后发表
fetch_assoc_one("SELECT count(*) FROM $art where $place like binary '%$keyword%'"); } else {$result = $db->fetch_assoc_one("SELECT count(*) FROM $art where $place like binary '%$keyword%' and id_cate2='$cate2'");} $totalnum = $result["count(*)"]; $page = new Page($totalnum,20); $startnum = $page->getPageStatus($totalnum,20); if($cate2=='all')//是否在所有版面查询 {$sql="SELECT * FROM $art where $place like binary '%$keyword%' order by $order desc limit $startnum,20";} else {$sql="SELECT * FROM $art where $place like binary '%$keyword%' and id_cate2='$cate2' order by $order desc limit $startnum,20";} $arrItems = $db->fetch_assoc($sql); $i=0; foreach($arrItems as $article) { ++$i; if($i%2==0) $color="#E1EBF5"; else $color="#99CCFF"; ?>
  "> |
outPutPage(); ?>
主题 作者 回复 人气 最后发表
query("SELECT count(*) FROM $art where name_rewriter='$writer'");} $sql="SELECT DISTINCT Article.* FROM Article LEFT JOIN Rearticle ON Article.ID = Rearticle.id_article where $place like binary '%$keyword%'"; else //{$total = $db->query("SELECT count(*) FROM $art where name_rewriter='$writer' and id_cate2='$cate2'");} $sql="SELECT DISTINCT Article.* FROM Article LEFT JOIN Rearticle ON Article.ID = Rearticle.id_article where $place like binary '%$keyword%' and Rearticle.id_cate2='$cate2'"; //$result = mysql_fetch_row($total); //$totalnum = $result["0"]; $query = @$db->query($sql) or die($db->get_error()); $totalnum = @$db->affected_rows(); $page = new Page($totalnum,20); $startnum = $page->getPageStatus($totalnum,20); if($cate2=='all')//是否在所有版面查询 {//$sql="SELECT * FROM $art where name_rewriter='$writer' order by $order desc limit $startnum,20"; $sql="SELECT DISTINCT Article.* FROM Article JOIN Rearticle ON Article.ID = Rearticle.id_article where $place like binary '%$keyword%' order by $order desc limit $startnum,20"; } else {//$sql="SELECT * FROM $art where name_rewriter='$writer' and id_cate2='cate2' order by $order desc limit $startnum,20"; $sql="SELECT DISTINCT Article.* FROM Article JOIN Rearticle ON Article.ID = Rearticle.id_article where $place like binary '%$keyword%' and Rearticle.id_cate2='$cate2' order by $order desc limit $startnum,20"; } $arrItems= $db->fetch_assoc($sql); $i=0; foreach($arrItems as $article) { ++$i; if($i%2==0) $color="#E1EBF5"; else $color="#99CCFF"; ?>
  "> |
outPutPage(); ?>
  查询文章  
查询方式:
关键词:
版面:
帖子属性:
 帖子排列顺序: