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 Quote 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.... Quote Link to comment https://forums.phpfreaks.com/topic/74696-solved-date-queries/#findComment-377698 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.