Array Print Out

[peterg0123]

Hi,

 

How can I print this multidimensional array out?  Below is a print_r of the array:

 

Array ( [-- No Parent --] => Array ( [0] => Array ( [category_id] => 1 [category_title] => -- No Parent -- ) ) [Microsoft] => Array ( [0] => Array ( [category_id] => 2 [category_title] => Microsoft ) [1] => Array ( [0] => Array ( [category_id] => 3 [category_title] => Outlook 2007 ) [1] => Array ( [0] => Array ( [category_id] => 7 [category_title] => Errors in Outlook ) ) ) [2] => Array ( [0] => Array ( [category_id] => 6 [category_title] => Microsoft Word 2007 ) ) ) [Maximizer] => Array ( [0] => Array ( [category_id] => 4 [category_title] => Maximizer ) [1] => Array ( [0] => Array ( [category_id] => 5 [category_title] => Server Side ) ) ) )

 

It is basically for a dropdown menu of categories.

 

Thanks in advance

Peter

[gaza165]

i would use a foreach loop on your array, for example

 

<?php

$array = array("one","two","three","four");

foreach ($array as &$value) {
    
echo $value."<br/>";

// ehos

//one
//two
//three
//four
}

?>

[peterg0123]

Hi,

 

Not sure that will work.  The array is built dynamically? Any other idea's.

 

Thanks

[gaza165]

http://www.phpf1.com/tutorial/php-multidimensional-array.html?page=3

 

this is a usefull link for printing multidimensional arrays

[peterg0123]

Hi,

 

Thanks for the link.  Tried it but it get the following:-

 

The actual Key is -- No Parent --.

---> 0 - Array

The actual Key is Microsoft.

---> 0 - Array

---> 1 - Array

---> 2 - Array

The actual Key is Maximizer.

---> 0 - Array

---> 1 - Array

 

I think I need a recursive function or something?

Peter

[gaza165]

i dont think ur array is being created properly. how is your array being constructed, copy the code.

[peterg0123]

<?php

function getTopCategories () 
{
return getSubCategories(0); /* top-level categories are just sub categories without a parent id */

}

function getSubCategories($parentId){
   $sql = "SELECT category_id,parent_id,category_title FROM tbl_categories WHERE parent_id = $parentId";
   $rs = mysql_query ($sql);
   $results = (array)NULL;
   while ($row = mysql_fetch_assoc($rs)) 
   {
      $id = $row["category_id"];
      $items = getItems($id);
      $subcategories = getSubCategories($id);
      $results[$row["category_title"]] = (array)NULL;
      
  foreach (array ($items, $subcategories) as $resultset) 
  {
         foreach ($resultset as $result) 
	 {
            $results[$row["category_title"]][] = $result;
         }
      }
   }
   return $results;
}
function getItems ($category_id) 
{
   $sql = "SELECT category_id,category_title FROM tbl_categories WHERE category_id='$category_id'";
   $rs = mysql_query ($sql);
   $results = (array)NULL;
   
   while ($row = mysql_fetch_assoc ($rs)) 
   {
      $results[] = $row;
   }
   return $results;
}


?>