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_image, $products_query = “select p.products_id, p.master_categories_id, p.products_status, pd.products_name, p.products_model, p.products_image,
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'].”,然後將這個字段輸出。 OK了！ OK了！