* Thus wrote Tim Owens:
> >
> > // 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
>
> Hmm. Could you simply use the SQL
> "WHERE WEEK(dateinrecord) = WEEK(dateinquestion)"? Or maybe use YEARWEEK to
> make sure you match the year too?
>
> Saves re-inventing the wheel...
You could but that will force a table scan where a between will use
an index with a range.
Curt
--
Quoth the Raven, "Nevermore."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
