[gbanse]

In the middle of the category.php file now. I think (it would be nice if someone could confirm this) this is the correct file that builds the lists of products for each category.

Have added my own query

if (defined('NEED_PRODUCT_CATEGORIES')) {
global $productid;
$_categories = func_query("SELECT $to_search, $sql_tbl[products_categories].productid, $sql_tbl[products_categories].main FROM $sql_tbl[categories] $join_tbl LEFT JOIN $sql_tbl[products_categories] ON $sql_tbl[categories].categoryid=$sql_tbl[products_categories].categoryid AND $sql_tbl[products_categories].productid='$productid' GROUP BY $sql_tbl[categories].categoryid");
$_upsell_link = func_query("SELECT $sql_tbl[product_links].productid2 FROM $sql_tbl[product_links] WHERE $sql_tbl[product_links].productid1 == $productid");
} else {
$_categories = func_query("SELECT $to_search FROM $sql_tbl[categories] USE INDEX (am) $join_tbl ".(!empty($search_condition)?"WHERE ".implode(" AND ", $search_condition):"")." GROUP BY $sql_tbl[categories].categoryid ".$sort_condition);
}

I'm trying to figure out how to get the result set (in my case a single product) in an array that I can use in the products.tpl file.