> Sorry for this post I know this is a mysql related question, i just wanna > have other comments.suggestions from this list. > I have a problem regarding date queries in mysql. Im creating inventory > 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... http://www.mysql.com/documentation/mysql/bychapter/manual_Reference.html #Date_and_time_functions ---John Holmes... -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php