Posted by Ehsan on 04/02/06 06:04

Try this:

SELECT id, date_format(date, '%D %M %Y') as date, title, article,
catagory, publication
FROM articles
WHERE MONTH(date) = extract(MONTH from NOW()) AND YEAR(date) =
extract(YEAR from NOW())
ORDER BY `date` DESC

Hope this helps.

Thanks and God Bless!!

Ehsan
http://ehsan.bdwebwork.com

[Back to original message]