Posted By

assbach on 02/25/07

Tagged

Viewed 904 times

Favorited by 2 user(s)

/ Published in: SQL

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

Comment:

You need to login to post a comment.