* Thus wrote msa ([EMAIL PROTECTED]):
>
> "Marek Kilimajer" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > date('m') was not parsed by php as it was in the string. Syntax
> > highlighting would help you see it. Try:
> >
> > "SELECT * FROM NewsArchive WHERE YEAR(date) = '" . date('Y') . "' AND
> > MONTH(date) ='" . date('m') . "' ORDER BY sort DESC";
>
> Well, still not working...but maybe closer? Not getting an error message,
> just not returning any data.....
You should pay attention to what your doing.
select month('2004-02-02');
2
echo date('m');
02
Curt
--
"I used to think I was indecisive, but now I'm not so sure."
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
