下面这段代码跑不起来 还要这么优化 请指点下if(!empty($cs_pro_info_pro_no_year)){
foreach($cs_pro_info_pro_no_year as $val){
$cs_pro_info_pro_no_query_year = $db -> query("select `pur_price`,`fanli_price`,`ywyc_price`,`sal_price`,`imei` from `oa_one_pro` where `product_id` = '".$val['pro_no']."'");
while($cs_pro_info_pro_no_array_year = $db -> fetch_array($cs_pro_info_pro_no_query_year)){
//pur_price采购价 ywyc_price业务预存款 fanli_price返利 sal_price卖价
if($val['business_type'] == 'main'){
$pur_price_main_year += $cs_pro_info_pro_no_array_year['pur_price'];
$fanli_price_main_year += $cs_pro_info_pro_no_array_year['fanli_price'];
$ywyc_price_main_year += $cs_pro_info_pro_no_array_year['ywyc_price'];
$sal_price_main_year += $cs_pro_info_pro_no_array_year['sal_price'];
}else{
$pur_price_other_year += $cs_pro_info_pro_no_array_year['pur_price'];
$fanli_price_other_year += $cs_pro_info_pro_no_array_year['fanli_price'];
$ywyc_price_other_year += $cs_pro_info_pro_no_array_year['ywyc_price'];
$sal_price_other_year += $cs_pro_info_pro_no_array_year['sal_price'];
}
//lhyc_price为靓号预存款
if(strlen($cs_pro_info_pro_no_array_year['imei']) == 11){
$sql = "select `num_yck` from `cs_new_num` A inner join `vte_numbers` B on A.num_id = B.id where B.number = '".$cs_pro_info_pro_no_array_month['imei']."'";
$query = $db -> query($sql);
$array = $db -> fetch_array($query);
//找不到则赋值为0
if(empty($array)){
if($val['business_type'] == 'main'){
$lhyc_price_main_year += 0;
}else{
$lhyc_price_other_year += 0;
}
}else{
if($val['business_type'] == 'main'){
$lhyc_price_main_year += $array['num_yck'];
}else{
$lhyc_price_other_year += $array['num_yck'];
}
}
}
}
}
}
foreach($cs_pro_info_pro_no_year as $val){
$cs_pro_info_pro_no_query_year = $db -> query("select `pur_price`,`fanli_price`,`ywyc_price`,`sal_price`,`imei` from `oa_one_pro` where `product_id` = '".$val['pro_no']."'");
while($cs_pro_info_pro_no_array_year = $db -> fetch_array($cs_pro_info_pro_no_query_year)){
//pur_price采购价 ywyc_price业务预存款 fanli_price返利 sal_price卖价
if($val['business_type'] == 'main'){
$pur_price_main_year += $cs_pro_info_pro_no_array_year['pur_price'];
$fanli_price_main_year += $cs_pro_info_pro_no_array_year['fanli_price'];
$ywyc_price_main_year += $cs_pro_info_pro_no_array_year['ywyc_price'];
$sal_price_main_year += $cs_pro_info_pro_no_array_year['sal_price'];
}else{
$pur_price_other_year += $cs_pro_info_pro_no_array_year['pur_price'];
$fanli_price_other_year += $cs_pro_info_pro_no_array_year['fanli_price'];
$ywyc_price_other_year += $cs_pro_info_pro_no_array_year['ywyc_price'];
$sal_price_other_year += $cs_pro_info_pro_no_array_year['sal_price'];
}
//lhyc_price为靓号预存款
if(strlen($cs_pro_info_pro_no_array_year['imei']) == 11){
$sql = "select `num_yck` from `cs_new_num` A inner join `vte_numbers` B on A.num_id = B.id where B.number = '".$cs_pro_info_pro_no_array_month['imei']."'";
$query = $db -> query($sql);
$array = $db -> fetch_array($query);
//找不到则赋值为0
if(empty($array)){
if($val['business_type'] == 'main'){
$lhyc_price_main_year += 0;
}else{
$lhyc_price_other_year += 0;
}
}else{
if($val['business_type'] == 'main'){
$lhyc_price_main_year += $array['num_yck'];
}else{
$lhyc_price_other_year += $array['num_yck'];
}
}
}
}
}
}
解决方案 »
- 这个实例,是否需要分表
- windows server2008 R2上安装SQL Server2005时出错
- 根据月份查询 比如2011-6-13 和 2011-6-14 查询 2011-6-14 的数据
- mysql 不能创建叫call的表
- mysql语句中如何取出一个值
- 请教一个多表模糊查询的嵌套SQL语句的写法
- 怎样将mysql数据库发布到网上?
- 斑竹或哪儿高人能整理一下MySQL中的一些bug吗?
- MySQL SERVER连出错
- 【求助】现有两个数据库,想要将两个数据库的产品表合并,但两个产品表的唯一标识不同
- 存储过程求高人!~~~~总是进入死循环
- 求个mysql自动备份的 批处理脚本,带删除的
此语句,并无特殊之处,建议你先在数据内执行一番,若正常,则说明你的while出问题了。