Explore our sites

Stack Exchange
tour help careers 2.0
Take the tour ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

I have the following script currently, which gets the category IDs as arrays:

$sql_select_categories = $db->query("SELECT category_id FROM " . DB_PREFIX . "categories 
    WHERE parent_id='" . intval($src_details['parent_id']) . "' 
ORDER BY order_id ASC, name ASC");  

    $additional_vars = set_filter_link($src_details, array('parent_id' => '', 'start' => ''), 'address');

    while ($cat_details = $db->fetch_array($sql_select_categories)) 
{
    $cat_array[$cat_details['category_id']]["name"]=$category_lang[$cat_details['category_id']];
}

if(is_array($cat_array)){

asort($cat_array);

    foreach($cat_array as $key => $value){

        $subcat_link = basename($_SERVER['PHP_SELF']) . '?parent_id=' . $key . $additional_vars;

        $output .= '<tr> '.
        '   <td class="contentfont">&nbsp;&raquo; <a href="' . $subcat_link . '">' . $category_lang[$key] . '</a></td> '.
        '</tr> ';
    }
}   
return $output;

This works perfectly, except I need to extract 1 more variable from the database which is called 'count'. so the mySQL query will change from

SELECT category_id FROM

to

SELECT category_id, count FROM

So far so good, but how do I get it to then display each of the counts in the foreach? I need them displayed in the HTML after $category_lang[$key] as something like $count.

Any help is greatly appreciated! I'm really bad with arrays.

share|improve this question
add comment

1 Answer

up vote 1 down vote accepted

Your $cat_details array will have another element that you can reference, which will be $cat_details['count']. You can then add that to your $cat_array like you do with that name element in the while loop.

$cat_array[ $cat_details['category_id'] ]['count'] = $cat_details['count'];

Make sense?

share|improve this answer
 
First of all thank you! Makes sense but something isn't working :( Do I add the $cat_array for the count as a 2nd line? Or somehow build it into the other one. Sorry, I just started learning with arrays and it's all very complicated! –  user1227914 Mar 27 '12 at 23:26
 
Do I change it to something like this? –  user1227914 Mar 28 '12 at 8:49
 
I got it working by adding another line of $cat_array below the other one. I printed the entire array in my browser and I see it's working, but can't figure out how to then print it as a $value. –  user1227914 Mar 28 '12 at 9:01
 
It now displays the values as: [215] => Array ( [name] => Category Name [items_counter] => 19 ) –  user1227914 Mar 28 '12 at 9:02
 
Sorry for the delay! Each $value will be an array, as well, so you will reference $value['count'] in the output foreach loop. –  uotonyh Mar 31 '12 at 1:02
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.