[embed=425,349]$query = “(SELECT * FROM database WHERE fldDate > DATE_SUB(DATE(NOW()), INTERVAL 1 MONTH) ORDER BY fldDate DESC LIMIT 4)”;
$query = “(SELECT * FROM database WHERE fldDate > DATE_SUB(DATE(NOW()), INTERVAL 14 DAYS) ORDER BY fldDate DESC LIMIT 4)”;
$query = “(SELECT * FROM database WHERE fldDate > DATE_SUB(DATE(NOW()), INTERVAL 7 DAYS) ORDER BY fldDate DESC LIMIT 4)”;[/embed]
Im a little confused here. It’s getting the records by the recent dates, such as today for example, instead of the records from 1 month ago, 14 days ago and 7 days ago. I need the records from those days but 4 records from each. What is the issue here?