WEEK() in PHP instead of MySQL??

[marms]

I have a problem I have put off until the week it matters.

I have a CMS that has date sensitive notices that the user get to contact their clients. I have it set to give them a notice a week in advance and it uses the MySQL WEEK() function.

WHERE WEEK(DO😎 = (WEEK('$DateToday')+1)

The problem is that this will not work this week because it is the last in this year and it will return a WEEK number that does not exist in the calendar. Any ideas how I can do this PHP side to get week 1 for next week or do it another way in MySQL?

Thanks