[Resolved] Fetching last entry

[bengt]

Hello

I used this earlier to get the last entry, but on Mysql 4.0.23 it doesn't work.

$sql = "SELECT DATE_FORMAT(dato, '%d/%m-%Y') as sistoppd FROM news WHERE dato = (SELECT max(dato) FROM news) LIMIT 1";

[devinemke]

to use subqueries you need mySQL 4.1 or higher

[bengt]

Is there another solution?

[devinemke]

$sql = "SELECT DATE_FORMAT(dato, '%d/%m-%Y') as sistoppd FROM news ORDER BY dato DESC LIMIT 1";

[bengt]

:queasy:

Of course... Thanx