我有个数据库查询操作查询出5个结果。
$sql="select name,picture,city from test where dunAnType='child' order by dunAnId desc limit 0,5;
$result=mysql_query($sql);
$mypic_array = new array(); while($row=mysql_fetch_array($result)){
//对数组赋值
}
?>
我的问题是怎么把查询的结果赋值给这个数组赋值呢?另外我怎么全部读取出赋值后的结果呢
急急急
$sql="select name,picture,city from test where dunAnType='child' order by dunAnId desc limit 0,5;
$result=mysql_query($sql);
$mypic_array = new array(); while($row=mysql_fetch_array($result)){
//对数组赋值
}
?>
我的问题是怎么把查询的结果赋值给这个数组赋值呢?另外我怎么全部读取出赋值后的结果呢
急急急
$sql="select name,picture,city from test where dunAnType='child' order by dunAnId desc limit 0,5;
$result=mysql_query($sql);$mypic_array = new array();while($row=mysql_fetch_array($result)){
$mypic_array = $row;
//对数组赋值
}
$sql="select name,picture,city from test where dunAnType='child' order by dunAnId desc limit 0,5;
$result=mysql_query($sql);$mypic_array = new array();while($row=mysql_fetch_array($result)){
$mypic_array[] = $row;
//对数组赋值
} 上面那个少打了
while($row = mysql_fetch_array($result , MYSQL_ASSOC)){ $mypic_array[] = $row;}
static $num=0,$new_array=array();
if(is_array($array)){
foreach($array as $key => $values){
$array[$key] = array_tree($values);
}
} else{
$new_array[$num] = $array;
$num++;
}
return $new_array;
}
array_tree($mypic_array);
自己写的一个函数,主要功能是把一个N维数组转换成一个一维数组,然后你在遍历这个一维数组就可以的!