Contributions

This is a modification of Tommy Le's work so that manufacturer's names will show instead of "Let's See What We Have Here" when listing products by manufacturer.

I also removed the unnecessary c.categories_image select from the SQL query.

Replace the existing title tags if any or add <TITLE></TITLE>.

Basically nything between "<TITLE>" and "</TITLE>" should get replaced with whats below.

<?php
if ($category_depth == 'nested') {
$category_query = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");
$category = tep_db_fetch_array($category_query);
$G = $category['categories_name'];
}
?><title><?php
if (HEADING_TITLE == "Let's See What We Have Here") {
$category_query1 = tep_db_query("select cd.categories_name, c.categories_image from " . TABLE_CATEGORIES . " c, " . TABLE_CATEGORIES_DESCRIPTION . " cd where c.categories_id = '" . (int)$current_category_id . "' and cd.categories_id = '" . (int)$current_category_id . "' and cd.language_id = '" . (int)$languages_id . "'");
$category1 = tep_db_fetch_array($category_query1);
if ($category1['categories_name'] != "") {echo $category1['categories_name'];} else { echo HEADING_TITLE;}
} else if (HEADING_TITLE == "Categories") {
print $category['categories_name'];
} else {
print HEADING_TITLE;
}
?></title>

Page Heading Title 1.0
----------------------
Get rid of "Let's See What We Have Here" for SubCategories and
"Categories" for Top-Categories. Replace them with the name of categories or Subcategories name.

easy to replace.