add(HEADING_TITLE, tep_href_link(FILENAME_SITE_MAP, '', 'NONSSL', true)); // should this line 20 be replaced with: // $breadcrumb->add(NAVBAR_TITLE, tep_href_link(FILENAME_SITE_MAP)); // ??? ?> > <?php echo $meta_data['categories_page_title']; ?>
"; } // just in case... // the following 18 lines are only necessary if some products belong directly to one of the main categories: // get the products id that belong to the main category: $prod_cat_query = tep_db_query("SELECT products_id, categories_id FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE categories_id= " . $categories['categories_id'] . " ORDER BY products_id"); while($prod_cat = tep_db_fetch_array($prod_cat_query)) { // get the product model and check the status of the products: $products_query = tep_db_query("SELECT products_id, products_model, products_status FROM " . TABLE_PRODUCTS . " WHERE products_id = " . $prod_cat['products_id']. " AND products_status=1 ORDER BY products_id"); $products_array = array(); while($products = tep_db_fetch_array($products_query)) { // get the product name in the selected language: $prod_name_query = tep_db_query("SELECT products_id, products_name FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = " . $prod_cat['products_id']. " AND language_id = '" . $languages_id . "' ORDER BY products_id"); $prod_name_array = array(); $prod_name = tep_db_fetch_array($prod_name_query); // display the product model and name with link (including language): echo ""; } echo ""; } // end of just in case... // let's go back to our usual tree Main Category -> Sub Category -> Products // get the sub categories (under each main category): $parents_query = tep_db_query("SELECT categories_id, parent_id, sort_order FROM " . TABLE_CATEGORIES . " WHERE parent_id= " . $categories['categories_id'] . " ORDER BY sort_order"); while($parents = tep_db_fetch_array($parents_query)) { // get and display their names: $sub_cat_desc_query = tep_db_query("SELECT categories_id, categories_name FROM " . TABLE_CATEGORIES_DESCRIPTION . " WHERE language_id = $languages_id AND categories_id = " . $parents['categories_id'] . ""); while($sub_cat_desc = tep_db_fetch_array($sub_cat_desc_query)) { echo ""; } // get the products id that belong to the sub category: $prod_cat_query = tep_db_query("SELECT products_id, categories_id FROM " . TABLE_PRODUCTS_TO_CATEGORIES . " WHERE categories_id= " . $parents['categories_id'] . " ORDER BY products_id"); while($prod_cat = tep_db_fetch_array($prod_cat_query)) { // get the product model and check the status of the products: $products_query = tep_db_query("SELECT products_id, products_model, products_status FROM " . TABLE_PRODUCTS . " WHERE products_id = " . $prod_cat['products_id']. " AND products_status=1 ORDER BY products_id"); $products_array = array(); while($products = tep_db_fetch_array($products_query)) { // get the product name in the selected language: $prod_name_query = tep_db_query("SELECT products_id, products_name FROM " . TABLE_PRODUCTS_DESCRIPTION . " WHERE products_id = " . $prod_cat['products_id']. " AND language_id = '" . $languages_id . "' ORDER BY products_id"); $prod_name_array = array(); $prod_name = tep_db_fetch_array($prod_name_query); // display the product model and name with link (including language): echo ""; } echo ""; // oh yes ! } echo ""; } echo ""; } ?>
" . $categories_desc['categories_name'] . "" . $products['products_model'] . "\n" . $prod_name['products_name'] . "
\n" . $sub_cat_desc['categories_name'] . "" . $products['products_model'] . "\n" . $prod_name['products_name'] . "


' . tep_image_button('button_continue.gif', IMAGE_BUTTON_CONTINUE) . ''; ?>