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.

SELECT `ID`, `artist`, `title` FROM `historylist` WHERE  ID IN (SELECT max(ID) FROM historylist)

That should do ya.

SELECT `ID`, `artist`, `title`
FROM `historylist`
WHERE `ID` = SELECT MAX(ID) FROM `historylist`;

Embedded SELECTs rock!

Edit:

quote:

---

Originally posted by wj
SELECT `ID`, `artist`, `title` FROM `historylist` WHERE  ID IN (SELECT max(ID) FROM `historylist`);

---

should also work.

Thanks for your help

optiz0r from IRC helped me too.

He gave me this code:

code:

---

SELECT  `artist` ,  `title`
FROM  `historylist`
ORDER  BY  `ID`  DESC
LIMIT 1

---

which also works