五十嵐 恭弘
igara****@clf*****
2007年 8月 1日 (水) 12:29:03 JST
お世話になります。
MySQLサーバーのバージョン： MySQL5.0.27-standard-log
default.php----------------------------------------------------------------------
172行目から
// show the products of a specified manufacturer
if (isset($_GET['manufacturers_id'])) {
if (isset($_GET['filter_id'])) {
// We are asked to show only a specific category
// $listing_sql = "select " . $select_column_list . "
p.products_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, IF(s.status, s.specials_new_products_price,
NULL) as specials_new_products_price, IF(s.status,
s.specials_new_products_price, p.products_price) as final_price from " .
TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left
join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where
p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and
m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'
and p.products_id = p2c.products_id and pd.products_id = p2c.products_id
and pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id
= '" . (int)$HTTP_GET_VARS['filter_id'] . "'";
// MySQL 5.0.X
$listing_sql = "select " . $select_column_list . "
p.products_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, IF(s.status, s.specials_new_products_price,
NULL) as specials_new_products_price, IF(s.status,
s.specials_new_products_price, p.products_price) as final_price from " .
TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on (
p.products_id = s.products_id ), " . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_status = '1' and p.manufacturers_id =
m.manufacturers_id and m.manufacturers_id = '" .
(int)$HTTP_GET_VARS['manufacturers_id'] . "' and p.products_id =
p2c.products_id and pd.products_id = p2c.products_id and pd.language_id
= '" . (int)$languages_id . "' and p2c.categories_id = '" .
(int)$HTTP_GET_VARS['filter_id'] . "'";
} else {
// We show them all
// $listing_sql = "select " . $select_column_list . "
p.products_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, IF(s.status, s.specials_new_products_price,
NULL) as specials_new_products_price, IF(s.status,
s.specials_new_products_price, p.products_price) as final_price from " .
TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_MANUFACTURERS . " m left join " . TABLE_SPECIALS . " s on
p.products_id = s.products_id where p.products_status = '1' and
pd.products_id = p.products_id and pd.language_id = '" .
(int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and
m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
// MySQL 5.0.X
$listing_sql = "select " . $select_column_list . "
p.products_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, IF(s.status, s.specials_new_products_price,
NULL) as specials_new_products_price, IF(s.status,
s.specials_new_products_price, p.products_price) as final_price from " .
TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on (
p.products_id = s.products_id ), " . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_MANUFACTURERS . " m where p.products_status = '1' and
pd.products_id = p.products_id and pd.language_id = '" .
(int)$languages_id . "' and p.manufacturers_id = m.manufacturers_id and
m.manufacturers_id = '" . (int)$HTTP_GET_VARS['manufacturers_id'] . "'";
}
// We build the categories-dropdown
$filterlist_sql = "select distinct c.categories_id as id,
cd.categories_name as name from " . TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_CATEGORIES . " c, " .
TABLE_CATEGORIES_DESCRIPTION . " cd where p.products_status = '1' and
p.products_id = p2c.products_id and p2c.categories_id = c.categories_id
and p2c.categories_id = cd.categories_id and cd.language_id = '" .
(int)$languages_id . "' and p.manufacturers_id = '" .
(int)$HTTP_GET_VARS['manufacturers_id'] . "' order by cd.categories_name";
} else {
// show the products in a given categorie
if (isset($HTTP_GET_VARS['filter_id'])) {
// We are asked to show only specific catgeory
// $listing_sql = "select " . $select_column_list . "
p.products_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, IF(s.status, s.specials_new_products_price,
NULL) as specials_new_products_price, IF(s.status,
s.specials_new_products_price, p.products_price) as final_price from " .
TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd, " .
TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left
join " . TABLE_SPECIALS . " s on p.products_id = s.products_id where
p.products_status = '1' and p.manufacturers_id = m.manufacturers_id and
m.manufacturers_id = '" . (int)$HTTP_GET_VARS['filter_id'] . "' and
p.products_id = p2c.products_id and pd.products_id = p2c.products_id and
pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '"
. (int)$current_category_id . "'";
// MySQL 5.0.X
$listing_sql = "select " . $select_column_list . "
p.products_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, IF(s.status, s.specials_new_products_price,
NULL) as specials_new_products_price, IF(s.status,
s.specials_new_products_price, p.products_price) as final_price from " .
TABLE_PRODUCTS . " p left join " . TABLE_SPECIALS . " s on (
p.products_id = s.products_id ), " . TABLE_PRODUCTS_DESCRIPTION . " pd,
" . TABLE_MANUFACTURERS . " m, " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c
where p.products_status = '1' and p.manufacturers_id =
m.manufacturers_id and m.manufacturers_id = '" .
(int)$HTTP_GET_VARS['filter_id'] . "' and p.products_id =
p2c.products_id and pd.products_id = p2c.products_id and pd.language_id
= '" . (int)$languages_id . "' and p2c.categories_id = '" .
(int)$current_category_id . "'";
} else {
// We show them all
// $listing_sql = "select " . $select_column_list . "
p.products_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, IF(s.status, s.specials_new_products_price,
NULL) as specials_new_products_price, IF(s.status,
s.specials_new_products_price, p.products_price) as final_price from " .
TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join "
. TABLE_MANUFACTURERS . " m on p.manufacturers_id = m.manufacturers_id,
" . TABLE_PRODUCTS_TO_CATEGORIES . " p2c left join " . TABLE_SPECIALS .
" s on p.products_id = s.products_id where p.products_status = '1' and
p.products_id = p2c.products_id and pd.products_id = p2c.products_id and
pd.language_id = '" . (int)$languages_id . "' and p2c.categories_id = '"
. (int)$current_category_id . "'";
// MySQL 5.0.X
$listing_sql = "select " . $select_column_list . "
p.products_id, p.manufacturers_id, p.products_price,
p.products_tax_class_id, IF(s.status, s.specials_new_products_price,
NULL) as specials_new_products_price, IF(s.status,
s.specials_new_products_price, p.products_price) as final_price from " .
TABLE_PRODUCTS_DESCRIPTION . " pd, " . TABLE_PRODUCTS . " p left join "
. TABLE_MANUFACTURERS . " m on ( p.manufacturers_id = m.manufacturers_id
) left join " . TABLE_SPECIALS . " s on ( p.products_id = s.products_id
), " . TABLE_PRODUCTS_TO_CATEGORIES . " p2c where p.products_status =
'1' and p.products_id = p2c.products_id and pd.products_id =
p2c.products_id and pd.language_id = '" . (int)$languages_id . "' and
p2c.categories_id = '" . (int)$current_category_id . "'";
}
// We build the manufacturers Dropdown
$filterlist_sql= "select distinct m.manufacturers_id as id,
m.manufacturers_name as name from " . TABLE_PRODUCTS . " p, " .
TABLE_PRODUCTS_TO_CATEGORIES . " p2c, " . TABLE_MANUFACTURERS . " m
where p.products_status = '1' and p.manufacturers_id =
m.manufacturers_id and p.products_id = p2c.products_id and
p2c.categories_id = '" . $current_category_id . "' order by
m.manufacturers_name";
}
202行目
default.php----------------------------------------------------------------------
以上、よろしくお願いします。
五十嵐