CodeIgniter Forums
avg and join, some help? - Printable Version

+- CodeIgniter Forums (https://forum.codeigniter.com)
+-- Forum: CodeIgniter 4 (https://forum.codeigniter.com/forumdisplay.php?fid=28)
+--- Forum: CodeIgniter 4 Support (https://forum.codeigniter.com/forumdisplay.php?fid=30)
+--- Thread: avg and join, some help? (/showthread.php?tid=75208)



avg and join, some help? - jolupa - 01-12-2020

Hi! I'm new to the forums I search on the forum and nothing comes as results, or maybe I didn't put the correct words.
The problem is I'm doing a little app with CodeIgniter, is years ago that I touch PHP and CodeIgniter, and I'm relearning all again doing this little app.
In this app I'm doing a table to show a list of games and one column of that game table is a user ratings of the game that I try to select from a table where all the gameID, userID, ratingSCORE are stored. So I have to perform an AVG select from the column with the SCOREs.
I have this code.
PHP Code:
      $builder $db->table('games')
                    ->join('developers''developers.developerID = games.developerID')
                    ->join('publishers''publishers.publisherID = games.publisherID')
                    ->join("SELECT AVG(ratingSCORE) FROM ratings group by ratings.gameID"'ratings.gameID = games.gameID')
                    ->orderBy('gameNAME''ASC');
      $query $builder->get();
      return $query->getResultArray(); 
When I put the third join the sql didn't work, I read that a subquery can be done in that form in some slack answers.
Can someone, please, showme some light on this?
Thanks a lot.