php页面代码简化,代码求简化

至

='".$mindate."' and dates<='".$maxdate."' and `type`='新增' and `area`='城南东'";$cndx=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='续费' and `area`='城南东'";$cndf=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='升兆' and `area`='城南东'";$cnds=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='免费' and `area`='城南东'";$cndm=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='新增' and `area`='城南西'";$cnxx=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='续费' and `area`='城南西'";$cnxf=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='升兆' and `area`='城南西'";$cnxs=mysql_result(mysql_query($sql),0);$sql="SELECT count(*) AS count FROM `khxx` WHERE dates>='".$mindate."' and dates<='".$maxdate."' and `type`='免费' and `area`='城南西'";$cnxm=mysql_result(mysql_query($sql),0);

城南东

城南西

回复讨论(解决方案)

查询那块写成函数不是更好点吗

$sql = "SELECT area, type, count(*) AS count FROM `khxx` WHERE dates>=‘$mindate’ and dates<=‘$maxdate’ group by area, type order by find_in_set(area, '城南东,城南西'), find_in_set(type,'新增,续费,升兆,免费')

$sql = "SELECT area, type, count(*) AS count FROM `khxx` WHERE dates>=‘$mindate’ and dates<=‘$maxdate’ group by area, type order by find_in_set(area, '城南东,城南西'), find_in_set(type,'新增,续费,升兆,免费')

主要是

我的table 是固定了 不知道怎么写在td中 如果没有就显示 0

想把相应的值 显示在固定了的表格中的单元格中

相关标签：代码求简化

本文原创发布php中文网，转载请注明出处，感谢您的尊重！