[RESOLVED] <Ol> <Li> and a loop with FOR or WHERE something

deepnots

I have a table consists of ID, linkcategory, Linkname and Linkhref

I want to show in my page in the way that

[INDENT]i.linkcategory1[/INDENT]
[INDENT][INDENT]1.Linkname1 (with its href)[/INDENT][/INDENT]
[INDENT][INDENT]2.Linkname2 (with its href)[/INDENT][/INDENT]

[INDENT]ii.linkcategory2[/INDENT]
[INDENT][INDENT]1.Linkname1 (with its href)[/INDENT][/INDENT]
[INDENT][INDENT]2.Linkname2 (with its href)[/INDENT][/INDENT]
[INDENT][INDENT]2.Linkname2 (with its href)[/INDENT][/INDENT]

...

How can I create this loop using <OL>, <LI> and PHP loop functions such as FOR or WHERE ?

Thank you

knucklehead

try something like this:

$linkcategory_group = "";
while ($row = mysql_fetch_array($query)) {

if($linkcategory_group != $row['linkcategory']) {
	$linkcategory_group = $row['linkcategory'];
	echo "<OL>".$linkcategory_group;
}

echo "<LI>".$row['Linkname']."(<a href='".$row['Linkhref']."'>"$row['Linkhref']."</a>)</LI>";
}

i think it could work 🙂....

bpat1434

Unfortunately what you want is slightly more difficult than Knucklehead's post. While close, it's not going to give you the result(s) you want.

If you are in fact using a mySQL result you'd do something like this:

<?php

while($row = mysql_fetch_assoc($result))
{
  $links[$row['linkcategory']][] = '<a href="'.$row['linkhref'].'">'.$row['linkname'].'</a>';
}
$html = '';
$current = '';
foreach($links as $cat=>$link)
{
  if($current != $cat)
  {
     if(!empty($current))
     {
        $html .= '</ol></li></ol>';
     }
     $current = $cat;
     $html .= '<ol><li>'.$cat.'<ol>;
  }
  $html .= '<li>'.$link.'</li>';
}

echo $html;
?>

That's not expected to be perfect code, but it should get you closer to what you want.

deepnots

thank you both bpat1434 & knucklehead, I tried both and bpat1434's code was more close to what I want but; the result is like this

1.linkcategory1
[INDENT]1. Array (also there is no link attached to this, it can't be clicked & there should be 2 linkname but it is only writing 1 Array text)[/INDENT]
1.linkcategory2
[INDENT]1. Array (also there is no link attached to this, it can't be clicked & there should be 2 linkname but it is only writing 1 Array text)[/INDENT]

Main OL part is OK but how may I echo <LI> parts that are linkname1, linkname2 ..etc for the related <OL> (linkcategory)

please give me the exact code if you can

thank you

bpat1434

Well, I would hope that you would have tried a few things if it didn't work out exactly as expected .... and the following line totally dissuades me from wanting to help you

please give me the exact code if you can

The reason you get the text "Array" is because an array is what's being echoed out. We have to iterate through that array for each value. It's a simple fix, but it was a minor mistake I made. A good search on here would have told you that.

But the looping code would look like:

while($row = mysql_fetch_assoc($result))
{
  $links[$row['linkcategory']][] = '<a href="'.$row['linkhref'].'">'.$row['linkname'].'</a>';
}

$html = '<ol>';
foreach($links as $cat=>$links)
{
  $html .= '<li>'.$cat.'<ol>';
  foreach($links as $link)
  {
    $html .= '<li>'.$link.'</li>';
  }
  $html .= '</ol></li>';
} 

echo $html;

deepnots

thank you so much. I have tried somethings but went far and far away from solution :-)

Your code is the exact solution and I have learnt from you

best regards🙂