我制作了一个php页面,我想从数据库中获取数据,但是当我运行它时,它发出警告“ mysql_num_rows()期望参数1为资源”。
我如何删除此警告?
这是我的代码:
$strQuery1 = "select DATE_FORMAT(transactions.transaction_date,'%m-%d-%Y') as transaction_date,sum(amount)as Amount from transactions where event_id='7' group by DATE_FORMAT(transactions.transaction_date,'%m-%d-%Y')";
$result1 = $GLOBALS ['mysqli']->query ($strQuery1) or die ($GLOBALS ['mysqli']->error . __LINE__);
$rows=mysql_num_rows($result1);
while($rs1=$result1->fetch_assoc()){
$res1[]=$rs1;
}
for ($i = 0 ; $i <=30 ; $i++) {
foreach($res1 as $r){
if($r['transaction_date']==$dates[$i]){
$substrXML1= "<set value='" . $r['Amount'] ."' />";
break;
} else
{
$substrXML1= "<set value='0' />";
}
}
$strXML1 .=$substrXML1;
}
$strXML1.="</dataset>";
$rows=mysqli_num_rows($result1);
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句