谢谢,运行成功了,这下搞清楚了$bqr与$bqsr的不同,
<?php $in=0; $chu=0; $jin=0; $year=0; $ecms_bq_sql=sys_ReturnEcmsLoopBq("SELECT SUM(shue) AS `ru`, YEAR(riqi) AS `nian` FROM phome_ecms_hyz WHERE classid =2 GROUP BY nian ORDER BY `nian` ASC",20,24,0); $bqno=0; while($bqr=$empire->fetch($ecms_bq_sql)) { $b=sys_ReturnEcmsLoopStext($bqr); $bqno++; echo "<br>"; $year=$bqr[nian]; echo "在".$year."年"; $in=$bqr[ru]; $in1=$in/10000; $ecms_bq_sql2=sys_ReturnEcmsLoopBq("SELECT SUM(shue) AS `chu` FROM phome_ecms_hyz WHERE classid =3 and YEAR(riqi)='$year'",20,24,0); $bqno2=0;
while($bqr2=$empire->fetch($ecms_bq_sql2)) { $bqsr2=sys_ReturnEcmsLoopStext($bqr2); $bqno2++; $chu=$bqr2[chu]; $chu1=$chu/10000; $jin=($in - $chu)/10000; echo "净收益为:".$jin."万元。<br>"; echo "其中收入是".$in1."万元,支出是".$chu1."万元。<br>"; echo "________________________<br>";
} } ?>
上传以下图片:
|