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");
Save my name, email, and website in this browser for the next time I comment.