要求的数组格式是这样的:/*
$data=array(array('cat_id'=>'1','cat_parent'=>0,'cat_name'=>'一级栏目一'),
array('cat_id'=>'2','cat_parent'=>0,'cat_name'=>'一级栏目二'),
array('cat_id'=>'3','cat_parent'=>1,'cat_name'=>'二级栏目一'),
array('cat_id'=>'4','cat_parent'=>1,'cat_name'=>'二级栏目二'),
array('cat_id'=>'5','cat_parent'=>2,'cat_name'=>'二级栏目三'),
array('cat_id'=>'6','cat_parent'=>3,'cat_name'=>'三级栏目一'),
array('cat_id'=>'7','cat_parent'=>3,'cat_name'=>'三级栏目二')
);
*/现在我从数据库中读出数据:
$query2 = "SELECT * FROM category ";$result_fenye = mysql_query($query2, $connect_db) or die(mysql_error());
$row_fenye = mysql_fetch_assoc($result_fenye);
$row_fenye2['cat_id'] = $row_fenye['auto_id'];
$row_fenye2['cat_name'] = $row_fenye['cat_name'];
$row_fenye2['cat_parent'] = $row_fenye['cat_parent'];
echo "<pre>";
print_r($row_fenye2);
echo "</pre>";明明数据库里有26条数据,
为什么只显示:
Array
(
[cat_id] =>
[cat_name] =>
[cat_parent] =>
)请问上面的代码,哪里错了?
我该怎么改?
$row_renye2 = array();
while($row_fenye = mysql_fetch_assoc($result_fenye)) {
$row_fenye2[] = array('cat_id' => $row_fente['auto_id'], 'cat_name' => $row_fenye['cat_name'], 'cat_parent' => $row_fenye['cat_parent']);
}
$row_fenye2['cat_id'] = $row_fenye['auto_id'];
$row_fenye2['cat_name'] = $row_fenye['cat_name'];
$row_fenye2['cat_parent'] = $row_fenye['cat_parent'];这么改
while($row_fenye = mysql_fetch_assoc($result_fenye))
{
$row_fenye2[] = $row_fenye;
}
while($row_fenye = mysql_fetch_assoc($result_fenye)){
$t['cat_id'] = $row_fenye['auto_id'];
$t['cat_name'] = $row_fenye['cat_name'];
$t['cat_parent'] = $row_fenye['cat_parent'];
$row_fenye2[] = $t;
}
while($row_fenye = mysql_fetch_assoc($result_fenye)){
$row_fenye2[] = array(
'cat_id' => $row_fenye['auto_id'],
'cat_name' => $row_fenye['cat_name'],
'cat_parent' => $row_fenye['cat_parent']
);
}