> Sorry for this post I know this is a mysql related question, i just
> have other comments.suggestions from this list.
> I have a problem regarding date queries in mysql. Im creating
> reports in PHP. I want to query from the date field a weekly report
for a
> specific month,  year, and week.

SELECT * FROM your_table WHERE YEARWEEK(your_date_column) = $x

Where $x is a YEARWEEK in the format YYYYWW. WW is 0 - 53. Read the
manual for more info...


---John Holmes...

PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to