note 57425 added to function.date

If you want to use date(‘W’, <TIME_STAMP>) to generate week numbers for mysql querys, you need to set the "mode" argument in the mysql YEARWEEK() function to a value that returns only weeks that have more than 3 days (1, 3, 4, 6). Example: <?php $sql = “SELECT project_name FROM project WHERE YEARWEEK(project_start_date, 1) = “.date(‘W’); ?> Check MySQL manual for more details. ---- Manual Page -- http://www.php.net/manual/en/function.date.php Edit -- http://master.php.net/manage/user-notes.php?action=edit+57425 Delete: added to the manual -- http://master.php.net/manage/user-notes.php?action=delete+57425&report=yes&reason=added+to+the+manual Delete: bad code -- http://master.php.net/manage/user-notes.php?action=delete+57425&report=yes&reason=bad+code Delete: spam -- http://master.php.net/manage/user-notes.php?action=delete+57425&report=yes&reason=spam Delete: useless -- http://master.php.net/manage/user-notes.php?action=delete+57425&report=yes&reason=useless Delete: non-english -- http://master.php.net/manage/user-notes.php?action=delete+57425&report=yes&reason=non-english Delete: already in docs -- http://master.php.net/manage/user-notes.php?action=delete+57425&report=yes&reason=already+in+docs Delete: other reasons -- http://master.php.net/manage/user-notes.php?action=delete+57425&report=yes Reject -- http://master.php.net/manage/user-notes.php?action=reject+57425&report=yes Search -- http://master.php.net/manage/user-notes.php