Getting month

[buzzt]

I have a column in my MySQL table which has dates (in the date column)in a yyy-mm-dd format. I need to use PHP to locate any data with whose month is the same as the current month. (All entries from 2003-09-01, to 2003-09-30 would be displayed).

What is the best way? How do I write the query?

 

[buzzt]

I think I got it.

select * from table where month(date_col)=month(curdate());

 

[sleipnir214]

Use PHP to fetch the current month and year. Something like:

list ($year, $month) = (explode (':', date('Y:m')));

Then I would use those two values to construct a query of the form:

SELECT .... FROM ....
WHERE month(datecolumn) = $month and year(datecolumn) = $year



Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

And if you have values from this month of last year?

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!

 

[sleipnir214]

Your all-SQL solution is better than mine.

Just make sure you constrain the year:

WHERE month(datecol) = month(now()) and year(datecol) = year(now())

Want the best answers? Ask the best questions:

http://www.catb.org/~esr/faqs/smart-questions.html

TANSTAAFL!!