<script type=text/javascript>
</script> <script src="http://pagead2.googlesyndication.com/pagead/show_ads.js" type=text/javascript> </script> <script> window.google_render_ad(); </script>
mysql_select_db($database_lr, $lr);
$query="select count(*) from product where articleid>0";
if($pinpaiid_productmain<>""){
$query.=" && pinpai='".$pinpaiid_productmain."'"; //
}
if($r_bigclassid<>""){
$query.=" && bigclassid='".$r_bigclassid."'"; //
}
if($r_smallclassid<>""){
$query.=" && smallclassid='".$r_smallclassid."'"; //
}
$rs=mysql_query($query);
$myrow = mysql_fetch_array($rs);
$numrows=$myrow[0];
如果有排序和分页的话类似这样的
$sql_1209=$sql_1209." order by smallclassid asc ,articleid desc limit $offset, $pagesize";
这个都是自己在用的,记录下来