[Coen Jeukens]

Newbie: I am writing my first vB php module and need some help in using the output results of my query.

I have created 2 functions:

1. function fetchforums() - this function runs a query and stores the data in an array
2. function foruminfo(x) - function will be called many times and should retrieve values from the array.

Running my query returns three columns of data (see picture1.png).

1. forumid
2. title
3. cntthreads

The code I use is:

PHP Code:

function fetchforums()
{
    global $vbulletin, $forumstructure;
    if (empty($vbulletin->iforumcache))
    {
        $forums = $vbulletin->db->query_read("
            SELECT forum.forumid, forum.title, count(*) AS cntthread
            FROM " . TABLE_PREFIX . "forum AS forum
            LEFT JOIN " . TABLE_PREFIX . "thread AS thread ON (forum.forumid=thread.forumid)
            GROUP BY forum.forumid, forum.title
            ORDER BY forum.forumid
        ");
        
        $result = array();
        while ($row = $vbulletin->db->fetch_array($forums)) {
            $result["$row[forumid]"] = $row;
        }
        unset($row);
        
        $vbulletin->db->free_result($forums);
    }

    return($result);
} 


I have tested the function as folllowing:

PHP Code:

$rc = fetchforums();
print_r(array_values($rc)); 


This gives me a result as shown in picture2.png.

In the second function I want to read the array.
I want to call the function like: (or equivalent)

PHP Code:

$rc1 = foruminfo(23,'title');
$rc2 = foruminfo(23,'cntthread');
echo "<li><a href="{$vbulletin->options[bburl]}/forumdisplay.php?f=23">$rc1</a> ($rc2)</li>"; 


Currently I have not been able to navigate the $rc array.

Q: How do I proceed?

Regards
Coen