I want to show products in category listing

[misbell]

I would like to show products in the category listing rather than categories of products or sub-categories. So, when I click on a product in the category listing, I would like it to take me to the product page, and not the page that provides a listing of products.

[misbell]

I'm new to osCommerce, and I realize the following is a hack, but I think it works. I realize that I will not be able to have sub-categories, which is what I want. Anyone see any implications elsewhere?


I made the following changes/additions to categories.php:function tep_show_category to change the href for the categories.

$cat_to_prod_query = tep_db_query("select products_id as prod_id from " . TABLE_PRODUCTS_TO_CATEGORIES . " where categories_id = '" . (int)$counter . "'");
$cat_prod = tep_db_fetch_array($cat_to_prod_query);
$products_id_new = '&products_id=' . $cat_prod['prod_id'];
$cPath_new .= $products_id_new;