从MySQL结果PHP多维数组 [英] Php multi-dimensional array from mysql result

问题描述

我有一个MySQL表，看起来像这样：

  ID | UID |标题|描述|亲
1 | 1 |肖像|说明。 |照片流
2 | 1 |摘要| DESCR。 |照片流
 

和我想建立一个将结束这样看多维数组：

 阵列
（
      [0]
          [ID] =＆GT; 1
          [UID] =＆GT; 1
          [标题] =＆GT;肖像
          [说明] =＆GT;说明。
          [家长] =＆GT;照片流
      [1]
          [ID] =＆GT; 2
          [UID] =＆GT; 1
          [标题] =＆GT;抽象
          [说明] =＆GT; DESCR。
          [家长] =＆GT;照片流
）
 

我使用的选择查询：

  $查询=的mysql_query（
  SELECT * FROM`table`其中`uid` ='1'ORDER BY`id` DESC）;
 

有谁知道如何做到这一点？
谢谢，
列维

解决方案

  $查询=的mysql_query（SELECT * FROM表其中uid ='1'ORDER BY ID DESC）;
$结果=阵列（）;
而（$行= mysql_fetch_array（$查询，MYSQL_ASSOC））{
    $结果[] = $行;
}
 

I have a mysql table that looks like this:

id | uid | title     | description | parent
1  |  1  | Portraits | desc.       | photostream
2  |  1  | Abstract  | descr.      | photostream

and I am trying to build a multi-dimensional array that would end up looking like this:

Array
(
      [0]
          [id] => 1
          [uid] => 1
          [title] => Portraits
          [description] => desc.
          [parent] => photostream
      [1]
          [id] => 2
          [uid] => 1
          [title] => Abstract
          [description] => descr.
          [parent] => photostream
)

I am using the select query:

$query = mysql_query(
  "SELECT * FROM `table` WHERE `uid`='1' ORDER BY `id` DESC");

Does anyone know how to do this? Thanks, Levi

解决方案

$query = mysql_query("SELECT * FROM table WHERE uid = '1' ORDER BY id DESC");
$results = array();
while($line = mysql_fetch_array($query, MYSQL_ASSOC)){
    $results[] = $line;
}

这篇关于从MySQL结果PHP多维数组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！