mysql动态菜单设计_php / mysql动态菜单

我有一个现有的下拉菜单，我试图将其转换为PHP / MySQL，以允许客户端编辑菜单项。这是结构：

首页 - 的index.php

关于我们 - #

   -about.php

   -annualreport.php

   -awards.php

服务 - #

   -services.php

   -loans.php

等等。我正在使用的查询是：

select distinct mainlinks.id as daddyid, mainlinks.title as daddytitle, mainlinks.urlink as daddyurl, babylinks.id as babyid, babylinks.title as babytitle, babylinks.urlink as babyurl from mainlinks, babylinks where mainlinks.id = babylinks.parentid order by mainlinks.listorder";结果显示在下面的代码中：

$result = mysql_query($query) or die(mysql_error());

// keep track of previous maincategory

$previous_maincategory = NULL;

while ($row = mysql_fetch_assoc($result))

{

// if maincategory has changed from previouscategory then display it

if ($previous_maincategory != $row['daddytitle'])

{

echo "

" . strtoupper($row['daddytitle']) . "

";

}

echo '';

echo $row['babytitle'];

echo "";

echo "
";

// record what the previous category was

$previous_maincategory = $row['daddytitle'];

}它只显示具有子元素的项目，而不显示没有子元素的父项目。有任何想法吗？我猜问题是查询where子句，但我无法弄清楚如何获取我需要的东西。谢谢。