购物车为空

Selling Gold?


Recently a jewellery store asked me to build an online version of their store. There was an unusual request, "Some of our products, like watches, have a fixed currency price, but the prices of our gold products like rings go up and down daily with the price of gold (XAU index)".

I developed a solution which enabled this functionality and this package is the exact solution now in use by that jewellery store.


插件版本: 1
下载链接: Selling Gold?

该商品加入分类的日期为 2015年 01月 03日

1055 Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column 'zencart.o.date_purchased' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in:
[select p.products_id, p.products_image from z138a_orders_products opa, z138a_orders_products opb, z138a_orders o, z138a_products p where opa.products_id = '13489' and opa.orders_id = opb.orders_id and opb.products_id != '13489' and opb.products_id = p.products_id and opb.orders_id = o.orders_id and p.products_status = 1 group by p.products_id order by o.date_purchased desc limit 6]