显示codeigniter中用户自己列表的平均评论和评分[关闭]

Question

I stuck in a problem that I want to show all the reviews of users own listing in a CodeIgniter project. There is two table in the database one is reviews and other is listings.

reviews table

listings table

common attribute is user_id and listed_by in both the tables. Now I want to get all the reviews of the listing which is created by user_id(2). Is it possible?

Answer 1

• Do a simple JOIN between the two tables based on listing id
• Select all reviews, based on the where condition, that is, listed_by = 2.

Try the following query:

SELECT r.* 
FROM reviews AS r 
JOIN listings AS l on l.id = r.listing_id 
WHERE l.listed_by = 2