PHP SQL Query: how to select same Ids?

Question

My code is:

$vote = DB::SELECT(DB::RAW("SELECT * FROM votes WHERE product_id = product_id; "));

Here[1] is a screenshot of my DB.

I'd like to ask how to select the same Producut Id in the SQL Query?

@u_mulder Would like to count all the votes. So I'm going to get all the same product ids — jamo
– jamo, Commented Oct 20, 2015 at 19:24

u_mulder · Accepted Answer · 2015-10-20 19:32:29Z

1

If you want to count sum of votes for each product and sort sum of votes from highest to lowest, then your query is:

SELECT 
    product_id, SUM(vote) as `vote_rate` 
FROM 
    votes 
GROUP BY 
    product_id 
ORDER BY 
    `vote_rate` DESC

answered Oct 20, 2015 at 19:27

u_mulder

54.8k5 gold badges54 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1