[RESOLVED] More trouble >.<

[Atomiku]

May sound noobish, But how can I get this:

Array
(
    [0] => Array
        (
            [category_id] => e9f05064bcfb342ac34f335c2bc98370
            [category_name] => ddd
            [parent_id] => 
            [sub] => Array
                (
                    [0] => Array
                        (
                            [category_id] => 129f30dd47d3a942b840ad2bf4ce5c4f
                            [category_name] => Testingz
                            [parent_id] => e9f05064bcfb342ac34f335c2bc98370
                            [sub] => Array
                                (
                                    [0] => Array
                                        (
                                            [category_id] => 2e9e963380a3fd4a1a6fb5050c9de331
                                            [category_name] => Sub-sub category
                                            [parent_id] => 129f30dd47d3a942b840ad2bf4ce5c4f
                                        )

                            )

                    )

            )

    )

[1] => Array
    (
        [category_id] => news
        [category_name] => News
        [parent_id] => 
    )

)

Into this:

DDD
-----Testingz
-----Testingz----Sub-sub category
News????

[hitman6003]

Assign the first (top level) array the var $top:

echo "$top[0]['category_name']<br>";
echo "----$top[0]['sub'][0]['category_name']<br>";
echo "----$top[0]['sub'][0]['category_name']----$top[0]['sub'][0]['sub']['category_name']<br>";
echo "$top[1]['category_name']";

[Atomiku]

Sorta, BUT thats not dynamic enough, What if theres more than one sub category?
or theres like a sub sub sub sub category?

Thanks anyway though, Pretty logical 😛

[drew010]

edit, use a while loop to keep finding the sub of the current array index until there isnt one?

[Atomiku]

What if there is a sub sub sub category? 😛 I need some kind of loop

[hitman6003]

Hehe

[leatherback]

You need to use recursion.

So you build a function that calls itself:

function recursion_now($array)
  {
   foreach($array as key => $value)
   if($key == 'sub')
      {
       recursion_now($value)
      }
   else
       {
        echo $value;
        }
  }

This in itself is by no means producing your output (Too lazy to fugure out exactly the specific logic for your problem) but the concept it\s what you need to look at.

J.

[Atomiku]

Well, I have the code that makes the array, Its perfect, BUT im not sure how to handle the array 🙁 the code is

function fetch_results($value=''){
	global $SQLObj;
	global $bcrumb;
	$array = array();
	$sql = "SELECT * from `pages_categorys` WHERE `belongto` = '$value'";
	$result = mysql_query( $sql ) ;
	$i = 0;
	while ($row = mysql_fetch_assoc($result)) {
		$rows[$i]['category_id'] = $row['id'];
		$rows[$i]['category_name'] = $row['category'];
		$rows[$i]['parent_id'] = $row['belongto'];
		$i++;
	}
	/*Now $rows should be a multi-array with your mySQL result in it. FOR is your friend, while is a tosser*/
	for($i=0;count($rows)>$i;$i++){
		if(empty($rows[$i]['category_id'])) continue;
		$array[$i] = $rows[$i];
		$result = fetch_results($rows[$i]['category_id']);
		if(empty($result)) continue;
		$array[$i]['sub'] = $result;
	}
	return $array;
}

Im not sure who coded this but it was someone from PHPBuilder.

Anyway, Is there any way I can get that print_r thing into a sorta breadcrumb navigation?

or just
DDD
DDD->Testingz
DDD->Testingz->Sub category
News

🙂#

Thanks in advance, Atomiku.

[leatherback]

Hi Atomiku,

Did you look at the snipped I posted? It is set to do just that, spit out your array. You will have to do some tweaking to get the exact output (Run an coutrer for the level for instance) but I posted it to generate OUTPUT, bnot an array. THe full array would go in.

[Atomiku]

Well, I am trying at it now
Ive currently being trying to do this (pretty much non stop) for about... 10 hours now lol

Its starting to p*** me off lol

Anyway, Ill post back with the working code abit later (if I get it done) for those who have the same problem as me 🙂

[leatherback]

Hi Atomiku,

This is how I implemented recursion for a menu structure. Hope it helps?

$menuquery = "select * from menu order by M_sortorder asc";

$result=mysql_query($menuquery) or die('An error occured retrieving data');

$listing = Array();


while($row = mysql_fetch_array($result))
  { 
  $listing[] = array("This_id"        => $row[M_page_nr], 
                     "path"           => $row[M_path],
                     "parent_id"      => $row[M_p_nr],    

                     "category_title" => $row[M_label], 
                     "link"           => $row['M_link']
                     );
  }

function display_tree($parent, $level, $array, $path)
{

foreach ($array AS $node)

  if($node[parent_id]==$parent)
    {
    $html .= "
    <a class=\"menu".$level."\" href=\"$path$node[path]$node[link]\">".$node[category_title]."</a>
    ";
         $html .= display_tree($node[This_id], ($level + 1), $array, $path);
    }

//  }

  return $html;

} // end display list


// Now use it

$menu = display_tree(0, 0, $listing, $baseurl);

[Atomiku]

Okay im now looking at it, If it works then you ARE THE BEST! 😃

[leatherback]

Something like this you asked?

<?

$array =  array(
0 => Array
        (
        "category_id"  => "e9f05064bcfb342ac34f335c2bc98370",
        "category_name" => "ddd",
        "parent_id" => "",
        "sub" => Array
                (
                    "0" => Array
                        (
                            "category_id" => "129f30dd47d3a942b840ad2bf4ce5c4f",
                            "category_name" => "Testingz",
                            "parent_id" => "e9f05064bcfb342ac34f335c2bc98370",
                            "sub" => Array
                                (
                                    0 => Array
                                        (
                                            "category_id" => "2e9e963380a3fd4a1a6fb5050c9de331",
                                            "category_name" => "Sub-sub category",
                                            "parent_id" => "129f30dd47d3a942b840ad2bf4ce5c4f"
                                         )
                                 )
                           )
                  )
           )
   );

   print_r($array);



 function recursion_now($array, $level)
  {
   foreach($array as $key => $value)
   if(is_array($value))
      {
      $level++;
       recursion_now($value, $level);
      }
   else
       {
       if($key == "category_name")
            {
            for($i==0; $i <= $level; $i++)
            {
            echo "----";
            }
            echo $value."\n\r";
          }
       }
  }  

echo "<pre>";
  recursion_now($array, 0);
echo "</pre>";  

  ?>

[Atomiku]

Cool cool, works fine. Thanks 🙂 FINALY!!!!
hehe

Anyway, im going to edit it abit so instead of:

--------DDDD

----------------Testingz

------------------------Sub-sub category

----------------------------Sub sub cate2

------------------------------------Sub sub sub cate :)

------------News

it will be something like:

DDDD
DDDD->Testingz

DDDD->Testingz->Sub-sub category
DDDD->Testingz->Sub sub cate2

DDDD->Testingz->Sub sub cate2->Sub sub sub cate :)

News

I will probably do so by changing level to like all parents...

[leatherback]

Ah, I get where you are going with this ;-)

Anyway. If it did the trick..., You know what to do right? Please mark the thread resolved.

J.