Error No: 1064 - MySQL error You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'GROUP BY a.activity_id ORDER BY aantal DESC' at line 1 Query: SELECT a.activity_id,a.naam,a.no_movies,count(movie_id) as aantal FROM activity a,movie p WHERE p.activity_id=a.activity_id AND p.merk_id= GROUP BY a.activity_id ORDER BY aantal DESC #0 /var/www/tip4.tagsite.nl/public_html/classes/class.merk.php(57): Mysql->execute('SELECT a.activi...')
#1 /var/www/tip4.tagsite.nl/public_html/controllers/show.php(2338): Merk->getMovieActivities(NULL)
#2 /var/www/tip4.tagsite.nl/public_html/controllers/show.php(2545): Show->mov_merk()
#3 /var/www/tip4.tagsite.nl/public_html/controllers/show.php(2561): Show->__construct(Object(mysqli))
#4 /var/www/tip4.tagsite.nl/public_html/index.php(12): include_once('/var/www/tip4.t...')
#5 {main}
filmpjes