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