Ok, habs:
SELECT a.*, MAX(b.id) AS lawid FROM posts a, posts b WHERE a.parentid=0 AND b.threadid=a.id GROUP BY id ORDER BY lawid DESC;
Hat ja lang genug gedauert.... ;)
greetz RFZ
nicht angemeldet nicht angemeldetOk, habs:
SELECT a.*, MAX(b.id) AS lawid FROM posts a, posts b WHERE a.parentid=0 AND b.threadid=a.id GROUP BY id ORDER BY lawid DESC;
Hat ja lang genug gedauert.... ;)
greetz RFZ