DarkPrince2005 Posted October 25, 2007 Share Posted October 25, 2007 I am trying to generate a report, with two tables: one containing carried over records(pending records from the previous month) and new matters(pending records from this month). I am thinking in theorie that it would require a date field that would contain the date the record was entered and then in the query take the current month and minus one from it to get the carried over records.And this report will be generated at the end of each month. and if anyone has a better idea please don't hesitate to let me know, but if not can anyone help me with what the mysql query would look like Link to comment https://forums.phpfreaks.com/topic/74696-solved-date-queries/ Share on other sites More sharing options...
clearstatcache Posted October 25, 2007 Share Posted October 25, 2007 do you have the structure of the two tables already? if yes, kindly show it.... Link to comment https://forums.phpfreaks.com/topic/74696-solved-date-queries/#findComment-377698 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.