//查询我关注的课程
$attention_course = $attention_model
->join(“left join cmf_course as c on cmf_users_attention.touid = c.id”)
->where(array( “cmf_users_attention.type” => 2, “cmf_users_attention.status” => 1, “cmf_users_attention.uid” => $uid, “c.status>0”))
->order(“cmf_users_attention.create_time desc”)->fetchsql(true)
->getField(“c.id,c.course_id,c.title,c.start_time,c.deadline,c.uid,c.costs,c.front_cover,c.type”);
tp3.2sql条件查询
最新推荐文章于 2022-05-18 22:52:56 发布