Developing first add-on - VB4
 

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:

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!

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 you could sneak peak in my plugins and see how i fetch multiple rows of data..

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