Month to Date Report

[horndog]

First off I am building reports with VB, not PHP.

I upgraded my development server to mysql 4.0 so I can do sub-selects.

I don't want any variables since the report is going to be fired off from a location where no variables are available.

What I want to do is:

I can get all the records in the current month, but not the year.

So if I do this:

SELECT * from table WHERE Month(date_col) = Month(Date_add(NOW(), INTERVAL 1 MONTH);

Then I just get all the records of this month, but not this year. So it will return all the records in April and not the current year, 2003. But all the years

[toma42]

add

and year(date_col) = 2003

[horndog]

I don't want the year and date hard coded, otherwise every year and month I have to change the code