Home > Backend Development > PHP Tutorial > 数据库数据调用有关问题

数据库数据调用有关问题

WBOY
Release: 2016-06-13 12:36:54
Original
1010 people have browsed it

数据库数据调用问题
表 business_circle
字段 id  name  parent_id 
       1   朝阳     0
       2   昌平     0
       3   大望路   1
       4   呼家楼   1
       5   朝阳公园 1

$sql1 = mysql_query("select * from business_circle order by id asc");
while($rs1 = mysql_fetch_assoc($sql1)){
echo $rs1['name'].$rs1['parent_id'].'
';
}
调出的结果是
大望路   1
呼家楼   1
朝阳公园 1

parent_id就是父类的id
我想调出的结果是
大望路 朝阳
呼家楼 朝阳
朝阳公园 朝阳


完整代码应当怎么写,高手帮忙下,直接给完整代码,谢谢

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template