Mam cztery tabele:
menu-------
id_kat (klucz podstawowy)
nazwa_kat_pl
menu_pod-------
id_pod (klucz podstawowy)
id_kat
nazwa_kat_pl
menu_pod_pod-------
id_pod_pod (klucz podstawowy)
id_pod
id_kat
nazwa_kat_pl
menu_pod_pod_pod-------
id_pod_pod_pod (klucz podstawowy)
id_pod_pod
id_kat
nazwa_kat_pl
Zrobiłem wyświetlenie kategorii, podkategorii, podpodkat:
<?php
$m2=mysql_query("select * from menu_pod where id_pod>1"); $m3=mysql_query("select * from menu_pod_pod where id_pod_pod>1"); $m4=mysql_query("select * from menu_pod_pod_pod where id_pod_pod_pod>1");
print "<table cellpadding='2' cellspacing='0' border='1'>";
{
print "<tr><td> • ".$ch1[nazwa_kat_pl
]."</li></td></tr>"; {
print "<tr><td> > ".$ch2[nazwa_kat_pl
]."</td></tr>"; {
print "<tr><td> >> ".$ch3[nazwa_kat_pl
]."</td></tr>"; {
print "<tr><td> >>> ".$ch4[nazwa_kat_pl
]."</td></tr>"; }
}
}
}
?>
No i próbowałem przerobić ten kod:
<table cellspacing="0" cellpadding="0" id="menu1" class="ddmx"> <a class="item1" href="javascript:void(0)">Products
</a> <a class="item2" href="example2.html">Product One
</a> <a class="item2 arrow" href="javascript:void(0)">Product Two
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Overview
</a> <a class="item2" href="example2.html">Features
</a> <a class="item2" href="example2.html">Requirements
</a> <a class="item2" href="example2.html">Flash Demos
</a> <a class="item2 arrow" href="javascript:void(0)">Product Three
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Overview
</a> <a class="item2" href="example2.html">Features
</a> <a class="item2" href="example2.html">Requirements
</a> <a class="item2" href="example2.html">Screenshots
</a> <a class="item2" href="example2.html">Flash Demos
</a> <a class="item2 arrow" href="javascript:void(0)">Live Demo
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Create Account
</a> <a class="item2 arrow" href="javascript:void(0)">Test Drive
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Test One
</a> <a class="item2" href="example2.html">Test Two
</a> <a class="item2" href="example2.html">Test Three
</a> <a class="item2 arrow" href="javascript:void(0)">Product Four
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Overview
</a> <a class="item2" href="example2.html">Features
</a> <a class="item2" href="example2.html">Requirements
</a> <a class="item2" href="example2.html">Product Five
</a>
<a class="item1" href="javascript:void(0)">Downloads
</a> <a class="item2" href="example2.html">30-day Demo Key
</a> <a class="item2 arrow" href="javascript:void(0)">Product One Download
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Linux Download
</a> <a class="item2" href="example2.html">Solaris Download
</a> <a class="item2" href="example2.html">Windows Download
</a> <a class="item2 arrow" href="javascript:void(0)">Product Two Download
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Linux Download
</a>
<a class="item1" href="javascript:void(0)">Support
</a> <a class="item2" href="example2.html">E-mail Support
</a> <a class="item2" href="example2.html">Phone Support
</a> <a class="item2" href="example2.html">WWW support
</a>
<a class="item1" href="javascript:void(0)">Partners
</a> <a class="item2" href="example2.html">Benefits
</a> <a class="item2 arrow" href="javascript:void(0)">Applications
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Application One
</a> <a class="item2" href="example2.html">Application Two
</a> <a class="item2" href="example2.html">Application Three
</a> <a class="item2" href="example2.html">Application Four
</a> <a class="item2" href="example2.html">Application Five
</a> <a class="item2" href="example2.html">Application Six
</a> <a class="item2" href="example2.html">Application Seven
</a> <a class="item2" href="example2.html">Listing
</a>
<a class="item1" href="javascript:void(0)">Customers
</a> <a class="item2" href="example2.html">Customer One
</a> <a class="item2" href="example2.html">Customer Two
</a> <a class="item2" href="example2.html">Customer Three
</a>
<a class="item1 bottom" href="javascript:void(0)">About Us
</a> <a class="item2" href="example2.html">Executive Team
</a> <a class="item2" href="example2.html">Investors
</a> <a class="item2" href="example2.html">Career Opportunities
</a> <a class="item2 arrow" href="javascript:void(0)">Press Center
<img src="images/arrow1.gif" width="10" height="12" alt="" /></a> <a class="item2" href="example2.html">Products Information
</a> <a class="item2" href="example2.html">Success Stories
</a> <a class="item2" href="example2.html">Contact Us
</a>
Błąd już przy drugiej pętelce, nie rozwija najeżdżając na kategorie główne:
<?php
print "<table cellspacing='0' cellpadding='0' id='menu1' class='ddmx'>"; {
print "<tr><td><a class='item1' href='javascript:void(0)'>$ch1[nazwa_kat_pl]</a>"; }
print "<div class='section'>";
{
print "<a class=item2 arrow' href='javascript:void(0)'>$ch2[nazwa_kat_pl]<img src='images/arrow1.gif' width='10' height='12' alt='' /></a>"; }
?>