[Solved] Limit MySQL Results to X Days [duplicate]

by


Sure. Create a time window and you can limit by that date

$time = time() - (86400 * 30); // 86400 seconds in one day
$sql="SELECT * FROM table WHERE datefield > "" . date('Y-m-d H:i:s', $time) . '"';

That should yield you records within the last 30 days

2

solved Limit MySQL Results to X Days [duplicate]