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";
?>
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";
?>