我可以使用循环从数据库结果集中创建一个像以下这样的PHP数组:
Array
(
[T] => Array
(
[0] => Array
(
[id] => 1
[name] => Timer
)
[1] => Array
(
[id] => 2
[name] => Tub
)
)
[P] => Array
(
[0] => Array
(
[id] => 3
[name] => Paper
)
[1] => Array
(
[id] => 4
[name] => Puppy
)
)
)
您会注意到数组键是一个字母,这个字母来自于结果集中的“name”值。循环将类似于以下内容:
while($result = $db->fetch($query) {
$key = $result['name']{0};
// your answer :-)
}