We can fetch the data older than a week in php. We use ‘Interval 7 Day’ to find the mysql result. Subtract the 7 days from current date.
PHP
$rs=mysqli_query($db,"SELECT * FROM `video` where date >= CURDATE() - INTERVAL 7 DAY");
PhpNo Comments
We can fetch the data older than a week in php. We use ‘Interval 7 Day’ to find the mysql result. Subtract the 7 days from current date.
$rs=mysqli_query($db,"SELECT * FROM `video` where date >= CURDATE() - INTERVAL 7 DAY");
Be the first to post a comment.