I’m wondering: how to get the average of a column in my database table displayed? And furthermore, how to display the average of a column for each row that has a certain integer in an another column?
Basically like a rating system, in which i have a rating column, a video column and a user column. I want to find the average rating for a certain video.
Can anybody help me?
Btw, i’ve already looked at the Statistical query part of The Guide, but i doesn’t understand it fully…
Now, just another question: What if i have multiple things of each video i want to be able to rate, but i don’t want to have more columns in my table besides an integer column that detects what kind of thing you are rating (like quality=1, acting=2 etc.)? So to display a rating, i’ll want to ask the database to give me a rating with a certain id, and a certain type.
I’m guessing i have to add a condition to the relation, such as ‘condition’ => ‘type=$type’ and then somehow get $type on the specific page, but i don’t know how to do that.