DarkPrince2005 Posted October 26, 2007 Share Posted October 26, 2007 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) Link to comment https://forums.phpfreaks.com/topic/74857-solved-date-query-intense-try-and-keep-up/ Share on other sites More sharing options...
fenway Posted October 26, 2007 Share Posted October 26, 2007 You need to use Date_Saved - INTERVAL 1 MONTH. Link to comment https://forums.phpfreaks.com/topic/74857-solved-date-query-intense-try-and-keep-up/#findComment-378607 Share on other sites More sharing options...
DarkPrince2005 Posted October 28, 2007 Author Share Posted October 28, 2007 Thanx for the help Link to comment https://forums.phpfreaks.com/topic/74857-solved-date-query-intense-try-and-keep-up/#findComment-379727 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.