Question

This question already has answers here:

Transposing multidimensional arrays in PHP (14 answers)

loop to populate html table vertically [duplicate] (7 answers)

Closed 2 years ago.

你们的表象

seed_id     name           country
-------     ----------     -------

1           John           America
2           Jose           Mexico
3           Khan           Pakistan

并且,你希望将《防止母婴传播公约》纵向描述如下;

seed_id     1             2           3
name        John          Jose        Khan
country     America       Mexico      Pakistan

这种观点在两种情况下都很简单。

你们想要印刷表格,或想对田地进行一面比较。

从印刷角度讲,在一份有50个领域的表格上,甚至印刷一个单一记录观点,也使你无法阅读。该文件将在第10个领域以印刷方式予以删除。

但是,从纵向角度看,这并不是表格中有多少领域。

同样,当你对记录进行旁边比较时,就象在这个美丽的例子中那样。

http://www.dpreview.com/products/compare/side-by-side?products=nikon_d90&products=nikon_d3&products=nikon_d4&sortDir=ascending

你非常有益。

I can sit down write this library function now but don t have the time at this moment. But I m sure someone out there has either the time for it, or already has written it. Would you please share it please?

概览(dbh,“从1=1的表X中选取”);

Answer 1

页: 1

SELECT * FROM mytbl G

UPD: 样本文章:http://slaptipill.com/soft/enabling-vertical-g-output-in-the-mysql-client/

Answer 2

这种做法可能更好......

$table = array();
foreach($result_row as $row)
{
  foreach(array( seed_id , name , country ) as $index)
  {
    $table[$index][] = $row[$index];
  }
}

象这样,应该重新组织你们的阵列,使其融入所需要的结构。

友情链接