OK I did this below and it works just great. I had stumbled across the message
earlier.
my next question would be. I'm working on a list of meetings. I return a list for
the
current month, what I would like to do is make the current week meetings show in red.
However, I'm not sure of the best approach to do this.
do I look at each date with a function of my own? or is there a php function I can use
that
I'm not aware of?
thanks for any and all help
chris
>for MySQL add a WHERE (WEEK(yourtimefield) = WEEK(NOW()))
>
>this will have the problem that it will show all of week X even if you're
>on 23:55 on the last day of that week
>
>WHERE ((yourtimefield >= NOW()) AND (yourtimefield <= DATE_ADD(NOW(),
>INTERVAL 1 WEEK))
>
>might be better
>
>--
>Christian Reiniger
>LGDC Webmaster (http://sunsite.dk/lgdc/)
>
>...10001000110101011010101101011110111010113...????
>
>--
>PHP General Mailing List (http://www.php.net/)
>To unsubscribe, e-mail: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]
>
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]
