/ Published in: SQL
![](/img/icon_sav.png?v3)
2 things here. currency (euro) with in a 2.00 format and select entries older than 4 weeks = 28 days
Expand |
Embed | Plain Text
Copy this code and paste it in your HTML
SELECT FORMAT(kontoinfo.betrag,2) AS betrag FROM konto WHERE USER = '".$uid."' AND konto.datum >= SUBDATE( NOW(), 28) ORDER BY konto.datum DESC
Comments
![RSS Feed for Comments RSS Icon](/images/rss.png?v3)