Question

thinkphp 如何写这样的代码 find();

$sql = "SELECT a.attr_name FROM ecs_attribute AS a, ecs_goods_attr AS ga, ecs_goods AS g WHERE a.attr_id = ga.attr_id AND g.goods_id = ga.goods_id AND g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='$value'";

if($temp_name = $db->getOne($sql))

请问用thinkphp find 怎么写

一般是这样
$M3 = M("ecs_brand");
$brand = $M3->field("`brand_id`,`brand_name`")->where("brand_id=" . (int) $brand_id)->find();

这种复杂的不会写啊，求帮助

Answer 1

M()->table('ecs_attribute a')->join('ecs_goods_attr ga on a.attr_id=ga.attr_id')->join('ecs_goods g on ga.goods_id=g.goods_id')->where("g.is_delete = 0 AND g.is_on_sale = 1 AND g.is_alone_sale = 1 AND a.attr_id='$value'")->find();

Answer 2

通过Model里面把几张表关联起来