[RESOLVED] Generating results based on the week of the year

[hackersapien]

Hi,

Database Server: Mysql 5.0
Language😛HP 5

I have to query a table and count the number of records according to the current week of the year.

example:

If the current week is the 25th, then I need to know how many people submitted an application on the 25th week. The table has a date field called timeofapplication.

I can query based on month,day,year by using the respective Mysql functions but am stuck on the part where I have to pull a recordset based on the week of the year.

Any help would be appreciated.

Cheers

[bogu]

SELECT * FROM `table` WHERE DATE_FORMAT(`date`,"%U") = '25'

[hackersapien]

bogu,

thanks bogu, I've also used the PHp function for date('W') to get the current week and pass it dynamically to the function.

Cheers,