[PHP] Letztes Datum aus DB ausgeben.

[omata]

Wie wäre es mit folgender Abfrage...

SQL-Code:

SELECT * 
FROM tbl_news 
WHERE news_lang = '$lang' 
  AND news_date = '$date'

UNION

SELECT * 
FROM tbl_news 
WHERE news_lang = '$lang' 
  AND news_date < '$date'
  AND (SELECT COUNT(*)
       FROM tbl_news 
       WHERE news_lang = '$lang' 
         AND news_date = '$date') = 0 

ORDER BY news_date DESC LIMIT 1,10

Gruss
Thorsten