output data from different dates?
I have thsi code.
<cfquery datasource ="Intranet" name="GetDeptSubmissions">SELECT * FROM CSEReduxResponses</cfquery>
<cfquery dbtype="query" name="GetPending">SELECT * FROM GetDeptSubmissions WHERE status = 1 AND execoffice_status = 0</cfquery>
<cfquery dbtype="query" name="GetApproved">SELECT * FROM GetDeptSubmissions WHERE status = 1 AND execoffice_status = 1</cfquery>
<cfquery dbtype="query" name="GetDenied">SELECT * FROM GetDeptSubmissions WHERE status = 1 AND execoffice_status = 2</cfquery>
<cfoutput>
<h2>Comments / Ratings Administration</h2>
<div>
<div class="display_count pending_outer">
<div class="display_count_desc pending_inner">Pending</div>
<cfif GetPending.RecordCount gt 0><a href="cse_execoffice_pending.cfm"></cfif>
<span class="display_count_number">#GetPending.RecordCount#</span>
<cfif GetPending.RecordCount gt 0></a></cfif>
</div><!--- /div class="display_count" --->
<div class="display_count approved_outer">
<div class="display_count_desc approved_inner">Approved *</div>
<cfif GetApproved.RecordCount gt 0><a href="cse_execoffice.cfm?approved"></cfif>
<span class="display_count_number">#GetApproved.RecordCount#</span><br>
<cfif GetApproved.RecordCount gt 0></a></cfif>
</div><!--- /div class="display_count" --->
<div class="display_count denied_outer">
<div class="display_count_desc denied_inner">Denied</div>
<cfif GetDenied.RecordCount gt 0><a href="cse_execoffice.cfm?denied"></cfif>
<span class="display_count_number">#GetDenied.RecordCount#</span><br>
<cfif GetDenied.RecordCount gt 0></a></cfif>
</div><!--- /div class="display_count" --->
</div>
</cfoutput>
and it works good. in this link is how it looks like http://i.stack.imgur.com/jEV1K.png
This gets all the data from table CSEReduxResponses, I want to create a new one for each month that the data comes in. for example
in table csereduxpesonses there is a column APPROVEDDATE (datetime) ,from this collumn i want to ouput the <div class="display_count pending_outer">for every month. so there will be one for APRIL , MAY , ect.
any suggestion on how to do this or examples would help , thanks
