你好,我试着做一些像我的查询:
result = mysql_query('SELECT subitems.ItemID,subitems.Parent,subitems.Data,items.ID FROM subitems INNER JOIN items ON items.ID = subitems.ItemID WHERE subitems.ItemID = '' . $ item ['ID'] . ''GROUP BY subitems.Parent ASC,subitems.Data ASC');
阵列(
[ItemID] => 1
(
[Parent] => 1
(
[Data] => 1
[Data] => 2
[Data] => 3
)
)
[ItemID] => 1
(
[Parent] => 2
(
[Data] => 1
[Data] => 2
[Data] => 3
)
)
)
我尝试制作foreach以查看itemID的每个父项并按父项显示每个项目,但不是每次都重写父项的名称 . 谢谢
1 回答
也许是嵌套的foreach(es)