Whenever I run this script something is going wrong because the max(), avg(), and min() values are coming up as 0. I have run is_null() on all of them and they are not NULL. They are just coming up as 0, but they shouldn't be. 1 vote has been "4" and 1 vote has been "2" so I should be coming up with an avg of 3, max of 4 and min of 2. I can only get COUNT() to work in the statement below, which is giving me the correct answer of 2.
Thanks. Any help is appreciated.
$get_advice_sql = "SELECT a.ID, a.person_ID, a.type, a.keywords, a.title, a.information, a.effect_start, Count(v.vote), Avg(v.vote), Max(v.vote), Min(v.vote), u.clsUserName FROM articles as a LEFT JOIN USERTABLE as u ON u.clsUserID = a.person_id LEFT JOIN votes as v ON a.ID = v.article_ID WHERE a.type = 'advice' AND a.ID = (SELECT max(ID) FROM articles WHERE type = 'advice') GROUP BY a.ID"; if ($result = mysqli_query($mysqli, $get_advice_sql)) { while ($row = mysqli_fetch_row($result)) { $advice_id = $row[0]; $title = $row[4]; $information = $row[5]; $effect_start = $row[6]; $votes_count = $row[7]; $votes_average = $row[8]; $votes_max = $row[9]; $votes_min = $row[10]; $author = $row[11]; } }
Sorry, I posted this question and realized that it was actually a problem while I was putting the initial data into MySQL. I was putting in the votes as 0's so of course it was coming up with 0 for the max, min, and average!
Feeling like an idiot :/
Sorry guys
0
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Feeling like an idiot :/
Sorry guys