note 100181 added to function.strtotime

If you're trying to make Saturday (or any other day for that matter) the first day of the week to select datasets, here's a good workaround: $last_sat=date("z", strtotime("last Saturday")); $second_last_sat=date("z", strtotime("last Saturday-1 week")); then just query your database like so: //select everything since last saturday SELECT whatever.whatever from wherever WHERE DAYOFYEAR(complete) <= DAYOFYEAR(CURDATE()) AND DAYOFYEAR(complete) > ".$last_sat." //the week before (beginning on a saturday) SELECT whatever.whatever from wherever WHERE DAYOFYEAR(complete) <= ".$last_sat." AND DAYOFYEAR(complete) > ".$second_last_sat." Good luck! ---- Server IP: 69.147.83.197 Probable Submitter: 206.130.179.8 ---- Manual Page -- http://www.php.net/manual/en/function.strtotime.php Edit -- https://master.php.net/note/edit/100181 Del: integrated -- https://master.php.net/note/delete/100181/integrated Del: useless -- https://master.php.net/note/delete/100181/useless Del: bad code -- https://master.php.net/note/delete/100181/bad+code Del: spam -- https://master.php.net/note/delete/100181/spam Del: non-english -- https://master.php.net/note/delete/100181/non-english Del: in docs -- https://master.php.net/note/delete/100181/in+docs Del: other reasons-- https://master.php.net/note/delete/100181 Reject -- https://master.php.net/note/reject/100181 Search -- https://master.php.net/manage/user-notes.php