[SOLVED] Date query... Intense Try and keep up

[DarkPrince2005]

I've got two web pages... The first one enables the user to select a month from a drop down list. the second then generates a report depending on the selected month, but it also has to generate the previous months report for comparison.

 

Ok the current months query would look like:

 

"Select * from dis where monthname(Date_Saved) like 'September';

 

But I am having trouble with the previous month's query:

 

"Select * from dis where monthname(Date_Saved) like '9-1';

          (where the 9 is gathered from the dropdownlist as the value for September)

[fenway]

You need to use Date_Saved - INTERVAL 1 MONTH.

[DarkPrince2005]

Thanx for the help