Developing first add-on - VB4

[reefland]

I am developing my first add-on for vb4 and could use some serious (and basic) php help, if you would be so kind.

I have a simple query looking for some info in the table cms_node:

$cms_sitefeature = vB::$db->query_read("SELECT * FROM " . TABLE_PREFIX . "cms_node WHERE parentnode = 5 LIMIT 4");

What I want to do is store the results of this query into an array, and until present the data in a template. I understand that I have to register the variables before I can output them (got this part figured out), what I do not know how to do is get this to display appropriately.

Since the results are limited to 4, each column has to be stored in an array I suppose. But then how do I get this to display foreach row in the template? is it done using a foreach in the php code or with a <vb:each in the template?

I feel like this is asking for some basics and I am not asking for someone to do it, just need to be steered in the right direction.

Thanks!

[Vaupell]

im using what you might consider

for each in vb terms in this modification (https://vborg.vbsupport.ru/showthread.php?t=232224)
But i use

PHP Code:

while()
{
  // do stuff
} 


you could sneak peak in my plugins and see how i fetch multiple rows of data..

[reefland]

Thanks much! I ended up going with the while {} approach, seemed much simpler.