来自mysql结果的Php多维数组 [英] Php multi-dimensional array from mysql result

问题描述

我有一个看起来像这样的 mysql 表:

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
)

我正在使用选择查询:

$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屋！