zencart实现一个商品多个价格

 

zencart建站如何實現一個商品多個價格？？？ 
總和上次的ZEN-CART添加一個新字段，這次根據新添加的字段，為一件商品添加兩 外兩種價錢，如：英文和日文。 添加好了以後，在index.php頁面添加這樣一個字段“$_SESSION[price_language]='語言标識';”在需要判斷的地方修改 SQL語句添加好了以後，在index.php頁面添加這樣一個字段“$_SESSION[price_language]='語言標識';”在需要判斷 的地方修改SQL語句  
$products_query = “select p.products_id, p.master_categories_id, p.products_status, pd.products_name, p.products_model, p.products_p_w_picpath, $products_query = “select p.products_id, p.master_categories_id, p.products_status, pd.products_name, p.products_model, p.products_p_w_picpath,  
p.products_price”.$_SESSION['price_language'].”, p.products_weight, p.products_tax_class_id, p.products_price”.$_SESSION['price_language'].”, p.products_weight, p.products_tax_class_id,  
p.products_quantity_order_min, p.products_quantity_order_units, p.products_quantity_order_min, p.products_quantity_order_units,  
p.product_is_free, p.products_priced_by_attribute, p.product_is_free, p.products_priced_by_attribute,  
p.products_discount_type, p.products_discount_type_from p.products_discount_type, p.products_discount_type_from  
from ” . TABLE_PRODUCTS . ” p, ” . TABLE_PRODUCTS_DESCRIPTION . ” pd from ” . TABLE_PRODUCTS . ” p, ” . TABLE_PRODUCTS_DESCRIPTION . ” pd  
where p.products_id = '” . (int)$products_id . “' where p.products_id = '” . (int)$products_id . “'  
and pd.products_id = p.products_id and pd.products_id = p.products_id  
and pd.language_id = '” . (int)$_SESSION['languages_id'] . “'”; and pd.language_id = '” . (int)$_SESSION['languages_id'] . “'”; 
if ($products = $db->Execute($products_query)) { if ($products = $db->Execute($products_query)) { 
$prid = $products->fields['products_id']; $prid = $products->fields['products_id'];  
$products_price = $products->fields['products_price'.$_SESSION['price_language']]; $products_price = $products->fields['products_price'.$_SESSION['price_language']];  
主 要是修改p.products_price”.$_SESSION['price_language'].”,然後将這個字段輸出。主要是修改 p.products_price”.$_SESSION['price_language'].”,然後將這個字段輸出。