0){ tep_redirect(tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $product_sub_check)); } //check to see if products have sub_products $product_has_sub = '0'; $sub_products_sql1 = tep_db_query("select p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_parent_id = " . (int)$HTTP_GET_VARS['products_id'] . " and p.products_quantity > '0' and p.products_id = pd.products_id and pd.language_id = " . (int)$languages_id); if (tep_db_num_rows($sub_products_sql1) > 0) { $product_has_sub = '1'; }else{ $product_has_sub = '0'; } /*/ //check to see if products have sub_products $product_has_slave = '0'; $sub_products_sql1 = tep_db_query("select p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_master = " . (int)$HTTP_GET_VARS['products_id'] . " and p.products_id = pd.products_id and pd.language_id = " . (int)$languages_id); echo "select p.products_id, p.products_price, p.products_image, pd.products_name from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_master = " . (int)$HTTP_GET_VARS['products_id'] . " and p.products_id = pd.products_id and pd.language_id = " . (int)$languages_id; if (tep_db_num_rows($sub_products_sql1) > 0) { $product_has_slave = '1'; }else{ $product_has_slave = '0'; } //*/ $content = CONTENT_PRODUCT_INFO; $javascript = 'popup_window.js'; require(DIR_WS_TEMPLATES . TEMPLATE_NAME . '/' . TEMPLATENAME_MAIN_PAGE); require(DIR_WS_INCLUDES . 'application_bottom.php'); ?>