如何用PHP MySQLi展示一对多关系的查询结果
一对多查询结果合并需求与问题
当前结果:
| Process | Skill |
|---|---|
| Process A | Skill_1 |
| Process A | Skill_2 |
| Process A | Skill_3 |
| Process B | Skill_1 |
| Process B | Skill_2 |
期望结果:
| Process | Skill |
|---|---|
| Process A | Skill_1, Skill_2, Skill_3 |
| Process B | Skill_1, Skill_2 |
示例SQL:
SELECT p.pid, p.process, p.product_id, p.sr_id, sr.pid, sr.process_id, sr.skill_req, sr.availability FROM p JOIN sr ON p.pid= sr.pid WHERE p.product_id= '20'
需要整理一对多关系的查询结果表格,尝试使用数组语句$array= array($row['skill_req']),但系统无法识别skill_req变量。
内容的提问来源于stack exchange,提问作者vb_newbie
相关产品推荐
相关产品推荐

