mysql - codeigniter Mysql加入查询结果

Question

我有三个表。用户，产品(user_id 是外键)，reviews_ratings (user_id & product_id 是外键)

mysql查询是

$pid = some id;
$this->db->select('*');
$this->db->from('reviews_ratings');
$this->db->join('users', 'users.id = reviews_ratings.user_id');
$this->db->join('products', 'products.id = reviews_ratings.product_id ');
$this->db->where('reviews_ratings.id >', $pid);
$this->db->order_by('reviews_ratings.id', 'DESC');
$this->db->limit(1);

结果，

Array ( [0] => stdClass Object ( [id] => 14 [title] => blaaa [review] => blaaaa [rate] => 4 soooo on))

[id]=>14 不是 review_ratings 表的 id。 14 是 product_id。除了这个 [id] 值，一切都很好。我想要 [id] 中的 review_ratings id 值。请帮我更正它。

Answer 1

尝试使用分组依据...

$pid = some id;
$this->db->select('*');
$this->db->from('reviews_ratings');
$this->db->join('users', 'users.id = reviews_ratings.user_id');
$this->db->join('products', 'products.id = reviews_ratings.product_id ');
$this->db->where('reviews_ratings.id >', $pid);
$this->db->order_by('reviews_ratings.id', 'DESC');
$this->db->group_by('reviews_ratings.id');
$this->db->limit(1);