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 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 ""; } ?>
Nyheder
LED belysning
Ecolight.dk deltager på messen Bolig i Bella
Ecolight.dk overtager Elektronik-butik.dk
Kontakt Ecolight.dk
Profil
Erhvervssalg
Fortrolighed
Forsendelse
Showroom
Køkken med LED belysning
Venteværelse med LED spots
Trappe med LED belysning
Havegang med LED lys
LED stylede biler
LED stylede scootere
LED stylede RC-biler
LED stylede computere
" . $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'] . "