Shoutbox

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.