How to read values in an array

[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:

function fetchforums() - this function runs a query and stores the data in an array
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).

forumid
title
cntthreads


The code I use is:
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:
$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)

$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

[Lynne]

You should be able to use the values in that array as $rc['forumid'], $rc['title'] and $rc['cntthread'] Loop through them?