* Thus wrote Jerry Swanson: > I need to run a query using PHP/MYSQL. The query should be for a week. > So if today is tuesday, the query should be from Monday to Sunday. > How in in php I can know when the beginning and end of the week? > <?php // in case the date unlikley changes $t = time(); // this weeks monday $m = strtotime('this monday', $t); // next weeks monday minus 1 second $s = strtotime('next monday', $t) - 1; echo date('r', $m), "\n"; echo date('r', $s), "\n" ?> Now $m and $s contain the proper timestamps. Curt -- Quoth the Raven, "Nevermore." -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php