我有写了个函数结果运行时候提示有错误,不晓得怎么的,请高手解答:
function profitability( )//收益力数据读取函数
{
$sql="select * from super_admin;";
$res=mssql_query($sql);
$row=mssql_fetch_array($res);
$year_num=$row["year_num"];
for($i=1;$i<=$year_num;$i++)
{
$sql="select * from profit where company_id=$name and fyear=$i;";
$res=mssql_query($sql);
$row=mssql_fetch_array($res);
$gp=$row["profit_grossprofit"];//毛利
$profit=$row["profit_profit"];//销售收入
$gain=$row["profit_gain"];//折旧前利润
$return=$row["profit_return"];//税前利润
$retain=$row["profit_retained"];//净利润
$mll=$gp/$profit;//毛利率
、、、、、、就是说折行错误,
$xsl=$gain/$profit;//销售利润率
$sql="select * from floatasset where company_id=$name and fyear=$i;";
$res=mssql_query($sql);
$row=mssql_fetch_array($res);
$total=$row["floatasset_total"];//流动资产合计
$sql="select * from fixedassets where company_id=$name and fyear=$i;";
$res=mssql_query($sql);
$row=mssql_fetch_array($res);
$ftotal=$row["fixedassets_total"];//固定资产合计
$sql="select * from equity where company_id=$name and fyear=$i;";
$res=mssql_query($sql);
$row=mssql_fetch_array($res);
$etotal=$row["equity_total"];//所有者权益合计
$zzc=$return/($ftotal+$total);//总资产收益率
$jzc=$retain/$etotal;//净资产收益率
//把数据存到数组
$array=array("$i"=>array("mll"=>"$mll","xsl"=>"$xsl","zzc"=>"$zzc","jzc"=>"$jzc"));
}
}