Code:
SELECT n.titel, n.nachricht FROM nachrichten n JOIN ( SELECT chat_id, MAX(datum) as maxdatum FROM nachrichten GROUP BY chat_id ) as sub on sub.chat_id = n.chat_id AND sub.maxdatum = n.datum
$md5 = md5 ( uniqid ( rand () ) );
SELECT n.titel, n.nachricht FROM nachrichten n JOIN ( SELECT chat_id, MAX(datum) as maxdatum FROM nachrichten GROUP BY chat_id ) as sub on sub.chat_id = n.chat_id AND sub.maxdatum = n.datum
Kommentar