$str_sql

"; $result=mysql_query($str_sql) or die(mysql_error()); while($row = mysql_fetch_object($result)) { $table_val[$row->category]=$row->counts; // echo "

".$row->category." ".$row->counts."

"; } $result = mysql_query("select * from $TableProdcategory order by id DESC"); $colindex = 0; if ($result) { while ($row = mysql_fetch_object($result)) { if ($colindex == 0) echo ""; $countres = mysql_query("select count(id) as num from $TableProdbreed where pid=$row->id"); $countrow = mysql_fetch_object($countres); echo ""; else echo $row->category." (0)"; } else { if ($table_val[$row->id]) echo "".$row->category." (".$table_val[$row->id].")"; else echo $row->category." (0)"; } $colindex = $colindex + 1; if ($colindex == 2) { echo ""; $colindex = 0; } } mysql_free_result($result); } if ($colindex < 2) { while ($colindex < 2) { echo ""; $colindex = $colindex + 1; } echo ""; } ?>

蔬菜优良品种:
"; if ($countrow->num) { if ($table_val[$row->id]) echo "".$row->category." (".$table_val[$row->id].")

优良品种检索:-)