On Tue, 2004-05-04 at 19:18, msa wrote:
> $query_rsENews = 'SELECT * FROM NewsArchive WHERE YEAR(datePublished) = ' .
> YEAR('NOW'()) . ' AND MONTH(datePublished) = ' . MONTH('NOW'()) . ' ORDER BY
> sortBy DESC';
>
>
> this is supposed to return only the records that have the current month and
> year in the datePublished record.
>
> got this error:
> Fatal error: Call to undefined function: year()
>
You sure you did not mean $dataPublished?
--
ray
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
