得到下一个即将到来的游戏，在星期一显示

Question

There will be games at saturdays but not every weekend. I Want to show on a new week if there is an upcoming game that following saturday.

I was thinking of something like this to check 6 days ahead if we are on ex monday, if there is a game that saturday it should find it. But of course it lacks parts, just a start but Im stuck. As for now it finds the next game which is 1 month away, it should only show if there is one that week.

"Select * From games Where date > DATE_ADD(CURDATE(),INTERVAL 6 DAY)"

Answer 1

You can use PHP's DateTime class to find the date for next Saturday:

$nextSaturday = new DateTime('next Saturday');

From there, just select where the date equals $nextSaturday->format('Y-m-d') to find the games (if any) for next Saturday.