Query selecteren laatste 7 dagen
Ik probeer nu reeds bijna een uur de data te selecteren van de laatste 7 dagen maar geraak niet echt verder...
Dit heb ik allemaal al geprobeerd
Code (php)
1
2
3
4
5
6
2
3
4
5
6
SELECT DISTINCT(ip) FROM statistics WHERE DATE(dtime) BETWEEN (NOW() - INTERVAL 7 DAY) AND CURRENT_DATE
SELECT DISTINCT(ip) FROM statistics WHERE dtime BETWEEN (NOW() - INTERVAL 7 DAY) AND CURRENT_DATE
SELECT DISTINCT(ip) FROM statistics WHERE dtime BETWEEN DATE_SUB(NOW(), INTERVAL -7 DAY) AND CURRENT_DATE
SELECT DISTINCT(ip) FROM statistics WHERE dtime > DATE_SUB(NOW(), INTERVAL 7 DAY)
SELECT DISTINCT(ip) FROM statistics WHERE DATE_SUB(CURRENT_DATE,INTERVAL 7 DAY) <= DATE(dtime)
SELECT DISTINCT(ip) FROM statistics WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= DATE(dtime)
SELECT DISTINCT(ip) FROM statistics WHERE dtime BETWEEN (NOW() - INTERVAL 7 DAY) AND CURRENT_DATE
SELECT DISTINCT(ip) FROM statistics WHERE dtime BETWEEN DATE_SUB(NOW(), INTERVAL -7 DAY) AND CURRENT_DATE
SELECT DISTINCT(ip) FROM statistics WHERE dtime > DATE_SUB(NOW(), INTERVAL 7 DAY)
SELECT DISTINCT(ip) FROM statistics WHERE DATE_SUB(CURRENT_DATE,INTERVAL 7 DAY) <= DATE(dtime)
SELECT DISTINCT(ip) FROM statistics WHERE DATE_SUB(CURDATE(),INTERVAL 7 DAY) <= DATE(dtime)
Niks wil werken, iemand die me te hulp kan schieten?
Mvg,
Gesponsorde koppelingen:
Code (php)
1
SELECT veld,veld2 FROM tabel WHERE tabelDatum > NOW - INTERVAL 7 DAY
copy/paste oplossing:
Code (php)
1
SELECT DISTINCT(ip) FROM statistics WHERE dtime > NOW() - INTERVAL 7 DAY
Moet het veld dtime wel minimaal een date, datetime of timestamp veld zijn.
Gewijzigd op 04/07/2011 11:05:59 door kees Schepers
Gewijzigd op 04/07/2011 11:18:04 door Wouter DS
