Shoutbox

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.