I am looking for a way to get past the HTML forced on me in
<mvt:item name="category_tree" />
I know I can loop through the Products array with
<mvt:foreach iterator="product" array="products">
and then just use &mvt:product:paramater_to_display/use
to get the info i want out of the products array.

Is there an array for the categories? What's it named?
I've been looking all over the miva site, my host's site and google
to figure this out- can't seem to find an answer anywhere?

Thanks,
Jon

Hi

I am also looking for this.

See this link http://extranet.miva.com/forums/showthread.php?t=304. Here I have placed my query here

Kumar

What I need is either something like this, or just a way to run a query and check a recordcount, ala:

<mvt:if RecordCount("SELECT mv5Categories.Name, mv5Products.Name
FROM (mv5Categories INNER JOIN mv5ProductCategories ON mv5Categories.CategoryID = mv5ProductCategories.CategoryID) INNER JOIN mv5Products ON mv5ProductCategories.ProductID = mv5Products.ProductID
WHERE ((mv5Categories.Name=\"CatName\") AND ((mv5Products.Name=\"ProdName\"));")>
Show Stuff Here For The Product If It's In Category 'CatName'!
</mvt:if>

(I have no idea what the table or field names are, this is very simply pseudocode.)