Panavision
-
Posts
4 -
Joined
-
Last visited
Never
Panavision's Achievements
Newbie (1/5)
0
Reputation
-
SELECT statement - display current month only
Panavision replied to Panavision's topic in MySQL Help
:oops: Missed it when I browsed it earlier, thanks -
SELECT statement - display current month only
Panavision replied to Panavision's topic in MySQL Help
Thanks, I did solve it in the end doing something similar What if I wanted to check against, say JULY 2002? news=mysql_query("SELECT * FROM (tblNews LEFT JOIN tblNews_Picture ON tblNews.News_ID = tblNews_Picture.News_ID), tblAuthor WHERE tblNews.Author_ID = tblAuthor.Author_ID AND MONTH(tblNews.NewsDate = month******) -
SELECT statement - display current month only
Panavision replied to Panavision's topic in MySQL Help
I tried this and didn\'t work, geez I suck at SQL statements Help please... :?: -
My problem is to DISPLAY news items where tblnews.newsdate = CURRENT MONTH. Also, how do I display news from previous months (for archive)?