Max(Avg(sql)) ??
Trying to figure out how to do a max on an average field. Can this be done at the PHP level or do I need server side stuff first.
Help much appreciated.
<?php
$RecordsetCreative = new WA_MySQLi_RS("RecordsetCreative",$xxxxx,1);
$RecordsetCreative->setQuery("SELECT Avg(tblStrainRatings.Rating) AS AvgRating, tblStrain.StrainName, tblQuestions.* FROM tblStrainRatings INNER JOIN tblStrain ON tblStrainRatings.StrainID = tblStrain.StrainID INNER JOIN tblQuestions ON tblStrainRatings.QuestionID = tblQuestions.QuestionID WHERE tblQuestions.QuestionCategoryID = 2 ORDER BY Avg(tblStrainRatings.Rating) DESC");
$RecordsetCreative->execute();
?>
SELECT Avg(tblStrainRatings.Rating) AS AvgRating, tblStrain.StrainName, tblQuestions.*
FROM tblStrainRatings INNER JOIN tblStrain ON tblStrainRatings.StrainID = tblStrain.StrainID INNER JOIN tblQuestions ON tblStrainRatings.QuestionID = tblQuestions.QuestionID
WHERE tblQuestions.QuestionCategoryID = 2
ORDER BY Avg(tblStrainRatings.Rating) DESC LIMIT 1