code:
SELECT MAX(ID), `artist`, `title` FROM `historylist`
It says:
quote:
Originally posted by mySQL Error
#1140 - Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
I tried doing something like that:
code:
SELECT MAX(ID), `artist`, `title` FROM `historylist` GROUP BY `ID`
but it didnt just show that Max(ID), it also showed other IDs, with wrong artists and titles...
Anyone help please?
Thanks.