At a glance it looks like you have everything you need in the
database. Which is good -- I was expecting an issue there.
In this case, I'd probably do a nested loop -- you need to be able to
loop through the submenu items. That also means limiting results at
the different levels of loop to the current level ONLY.
Probably start with something like this:
$sql = 'SELECT * FROM menu WHERE parentid = PARENT_ID_GOES_HERE';
That way, when you loop through your results, all you're getting are
the top level results for the child you're on. As you hit each
result, you'll need to pop the database to check for children.
Personally, I'd move away from mysql_fetch_array -- it can be tough
to manage, and gives you a lump set of info. My preference in a case
like this would generally be a combination of a FOR loop and
mysql_result.
Something like this seems appropriate:
for ($i = 0; $i < mysql_num_rows($rows); $i++)
Then, for each id that you roll across, you call your nested loop
function with the SQL statement.
This will also give you the flexibility for if you have a lot of
navigation, and a lot of children <ul>'s.
If you have any problems with the new code that you write, hit us up.
--
Joe
On Jun 1, 2010, at 11:08 AM, Sovichea SOU wrote:
> $sql = "SELECT * FROM menu";
> $rows = mysql_query($sql, $con);
>
> if(mysql_num_rows($rows > 0)){
>
> while($record = mysql_fetch_array($rows)){
> $title = $record["title"];
> echo "<li>$title</li>";
>
>
> }
>
>
> }
>
> On Tue, Jun 1, 2010 at 10:57 PM, Joe Forsythe
> <jforsythe@xxxxxxxxxxxxxxxxxx>wrote:
>
>>
>>
>> What is the PHP code that you're using right now?
>> --
>> Joe
>>
>>
>> On Jun 1, 2010, at 10:41 AM, Sovichea SOU wrote:
>>
>>> Hello Joe,
>>>
>>> Thanks for your fast reply.
>>>
>>> I can loop only like this:
>>>
>>> <ul>
>>> <li>Item1</li>
>>> <li>Item2</li>
>>> <li>Item2a</li>
>>> <li>Item2b</li>
>>> </ul>
>>>
>>> It should be look like this with nested list:
>>>
>>> <ul>
>>> <li>Item 1</li>
>>> <li>Item 2
>>> <ul>
>>> <li>Item 2a</li>
>>> <li>Item 2b</li>
>>> </ul>
>>> </li>
>>> </ul>
>>>
>>> This is database:
>>>
>>> id - title - link - parentid
>>> 1 - Item1 - http://www.yahoo.com - 0
>>> 2 - Item2 - http://www.google.com - 0
>>> 3 - Item2a - http://www.chhit.com - 2
>>> 4 - Item2b - http://www.gmail.com - 2
>>>
>>> Could you tell me how to write this kind of loop?
>>>
>>> Thanks,
>>>
>>> Vichea
[Non-text portions of this message have been removed]
