I have a table called "Events" and there i have an attribute date
Does anyone know how to retrieve reconds related to the current week only?

Make sure to store your dates like this....

20040312000000 <----just example date.

This way you can do a query like this...

SELECT * FROM Events WHERE date BETWEEN 20040312000000 AND 20040312235959

Get the idea? I've never used it, just found this through google.

cptn,

that is a datetimestamp. Your search is actually only searching one day. I do not think this is what he is after bud.

I will try and do a wee tutorial for you on stripping dates in the morning, but there are plenty of PHPers who do not need to go to bed just now - i.e. non British - and they might do it earlier.

Steve.

You could use the WEEK function, I suppose.

SELECT * FROM events WHERE WEEK( mydate ) = WEEK( CURDATE() )

Ever look at a word for a while and think, wow, that is a weird word? Week is a weird word! =D

I dind't know that there is a WEEK function . Thisn is what i actually need.

Thank you

Originally Posted by Gaffer Sports

cptn,

that is a datetimestamp. Your search is actually only searching one day. I do not think this is what he is after bud.

I will try and do a wee tutorial for you on stripping dates in the morning, but there are plenty of PHPers who do not need to go to bed just now - i.e. non British - and they might do it earlier.

Steve.

I know that it was only a day. I was not trying to do it for him but give him a clue as to how to accomplish this so I just put whatever dates. However, as Chroder pointed out a function that even I did not know about, that appears as though it will accomplish this task much better.

Yep, top marks to Chroder as it appears none of us knew about the Week function..