hello..
i am creating cmc pages from admin side. i have 3 level menu in front end. my database table structure for cms pages 'name,parent_id,description,status'.
now i have to display all pages subpages and sub of subpages in menu.
how to write this query?
<!-- BEGIN Menu -->
<ul id="nav">
<li><a href="consumers.php">Consumers</a>
<ul><li><a href="personal_finance.php">Personal Finance </a>
<ul><li><a href="personal_financial_makeover.php">Personal Financial Makeover</a></li>
<li><a href="personal_finance_consultancy.php">Personal Finance Consultancy</a></li>
</ul>
</li>
<li><a href="investings.php">Investings</a>
<ul>
<li><a href="securities_analysis.php">Securities Analysis</a></li>
<li><a href="portfolio_investment.php">Bernie Madoff Shield (Portfolio and Investment Analysis)</a></li>
</ul>
</li>
</ul>
</li>
<li><a href="entrepreneurs.php">Entrepreneurs</a>
<ul>
<li><a href="market_analysis.php">Market Analysis and Competitive Report </a></li>
<li><a href="business_plans_feasibility.php">Business Plans & Feasibility Studies </a>
<ul>
<li><a href="business_plans.php">Business Plans</a>
<ul>
<li><a href="level1.php">Level 1</a></li>
<li><a href="level2.php">Level 2</a></li>
<li><a href="level3.php">Level 3</a></li>
</ul>
</li>
</ul>
</li>
</ul>
<!-- END Menu -->