Return to Snippet

Revision: 2465
at February 25, 2007 08:32 by assbach

Initial Code
FORMAT(kontoinfo.betrag,2) as betrag
FROM konto
WHERE user = '".$uid."'
AND konto.datum >= SUBDATE( NOW(), 28)
ORDER BY konto.datum DESC

Initial URL

Initial Description
2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days

Initial Title
SELECT older than x days

Initial Tags
mysql, date

Initial Language