$sql="select * from goods_class as a,goods_detail as b where a.id=b.class_id and a.id='$_GET[id]'";
$query=$db->query($sql);
while($row_class=$db->fetch_array($query)){
$sm_class[]=array("name"=>$row_class[b.name],"id"=>$row_class[b.id],"picture"=>$row_class[b.picture]); }
print_r($sm_class);输出结果为空,求帮助!!
$query=$db->query($sql);
while($row_class=$db->fetch_array($query)){
$sm_class[]=array("name"=>$row_class[b.name],"id"=>$row_class[b.id],"picture"=>$row_class[b.picture]); }
print_r($sm_class);输出结果为空,求帮助!!
给你步骤,自己调试
1.echo $sql;看是否是预期的结果(主要看id是否取到值),如果正确。进行第二步2.while($row_class=$db->fetch_array($query)){
这里之前加上一句话
$sm_class = array();
也就是
$sm_class = array();
while($row_class=$db->fetch_array($query)){
print_r($row_class);//打印取出的数据,是否正确;
}
print_r();
试试
????键名写错了