DarkPrince2005 Posted October 24, 2007 Share Posted October 24, 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/74619-solved-queries/ Share on other sites More sharing options...
sKunKbad Posted October 24, 2007 Share Posted October 24, 2007 Is there a reason why previous records and current records can't be kept in the same table? If not, you could have two seperate queries, and as long as the names of the fields of each table aren't the same, you could merge the two arrays together, extract the array into variables, and then output as desired. I would simply create select queries by user ID, customer number, or something similar. Quote Link to comment https://forums.phpfreaks.com/topic/74619-solved-queries/#findComment-377297 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.