数据表:
id uid username
1 lisi 李四
3 zhangsan 张三
4 mazi 麻子想转成这样格式的二维数组:Array
(
[0] => Array
(
[0] => 1
[1] => admin
[2] => 系统管理员
) [1] => Array
(
[0] => 2
[1] => zs
[2] => 张三
) [2] => Array
(
[0] => 3
[1] => lisi
[2] => 李四
) [3] => Array
(
[0] => 4
[1] => mz
[2] => 麻子
) ))
id uid username
1 lisi 李四
3 zhangsan 张三
4 mazi 麻子想转成这样格式的二维数组:Array
(
[0] => Array
(
[0] => 1
[1] => admin
[2] => 系统管理员
) [1] => Array
(
[0] => 2
[1] => zs
[2] => 张三
) [2] => Array
(
[0] => 3
[1] => lisi
[2] => 李四
) [3] => Array
(
[0] => 4
[1] => mz
[2] => 麻子
) ))
Array
(
[0] => Array
(
[0] => 1
[1] => lishi
[2] =>李四
) [1] => Array
(
[0] => 3
[1] => zhangsan
[2] =>张三
) [2] => Array
(
[0] => 4
[1] => mz
[2] => 麻子
) ))
我只能转成这样的:
Array
(
[0] => Array
(
[user_id] => admin
[user_name] => 系统管理员
) [1] => Array
(
[user_id] => zs
[user_name] => 张三
) [2] => Array
(
[user_id] => lisi
[user_name] => 李四
) [3] => Array
(
[user_id] => mz
[user_name] => 麻子
))
这两种区别就是一个是用数字作为索引一个是以数据库字段作为索引,可能是用这个方法引起的
while($row = mysql_fetch_array($result,MYSQL_ASSOC))
while($array[] = mysql_fetch_array('select id,uid,username from table'));$array[] = array(0,1,'系统管理员');
$result = mysql_fetch_array($query);
.
/**处理数据 **/
.
.mysql_free_result($result);