Question

ECShop 查询某个商品的所有属性字段名称和其对应的属性值 这个sql语句怎么写?

哪位大神，能告诉我，
ECShop 查询某个商品的所有属性字段名称和其对应的属性值 这个sql语句怎么写？

Answer 1

$sql = "SELECT ga.goods_attr_id, ga.attr_value
FROM " .$GLOBALS['ecs']->table('goods_attr'). " AS ga, " .$GLOBALS['ecs']->table('attribute'). " AS a
WHERE a.attr_id = ga.attr_id
AND a.attr_type = 1
AND " . db_create_in($goods_id_array, 'goods_id');