Week start and end dates

[jakehowl]

Hi all,

My first post here ;o)

I want to be able to work out the start and end days of the week that the current day is in.

Eg. today is Tuesday so I want to script somethign that will get the date of Monday (yesterday) and of next Sunday so that I can then construct a SQL "between" statement to get all events happening this week.

Not asking for code but just methodology so that I know the right line to follow.

Am I right in thinking that I would say "What day is today?" and then work out how many days to add and subtract from the date object to get to the required day. Is there not a simpler in-built functiont that I am missing?

Jake

[jdh]

Check out the week() function from MySQL.

For example:

$sql = "SELECT * FROM table WHERE WEEK(date) = WEEK(NOW())";

Would return all the entries that are in this week, the 39th week of th year. All of them would range from 22-28.

To search for entries that are between that range, you can do something like this.

$sql = "SELECT * FROM table WHERE WEEK(date) BETWEEN WEEK($from) AND WEEK($to)";

Hope this helps.

[jakehowl]

Brilliant. I knew there had to be a nice simple solution.