Listing info by date

[mswantek]

Hi. I am trying to loop over data from my db to produce a listing and header similar to craigslist posting.

I need to display all items listed for date "such and such" and then go to the next previous date and do the same thing.

<sql:query var="listall" dataSource="jdbc/PPOefab" >
SELECT *
FROM gmlistmain
ORDER BY  datePosted ASC
</sql:query>

<jsp:useBean id="current" class="java.util.Date"/>
<fmt:formatDate var="dateFormatted" value="${current}" type="both"/>
<c:out value="${dateFormatted}"/>
<table width="88%" border="0" cellpadding="10" cellspacing="10">
  <c:forEach items="${listall.rows}" var="listallRows">
    <tr>
    <td >&nbsp;${listallRows.datePosted}</td>
        <td>&nbsp;<a href="detail.jsp?recordID=${listallRows.posting_ID}">${listallRows.postingTitle}</a>  ( ${listallRows.location} ) </td>
    <td>&nbsp;${listallRows.postingDescription} </td>
  </tr>
  </c:forEach>
</table>

This produces a listing but shows the date every time. How can I just show the date once (formatted as a heading) , list all the items listed on that date, and then move onto the next previous date and list all items on that day, and continue on till 30 days from today are listed. Again, a craigslist listing is similar to what I am looking for.


I know I will need to loop over, but I am not able to figure this out. Any help would be appreciated.

[mtyoung]

c:set var="tmp" value="0"
compare the date and tmp variable, if they have differences, display the date and update tmp variable to valud of date

[mswantek]

MTYOUNG,

Thanks for your reply. Using the distinct method in SQL, I looped through the dates and created the virtual table of distinct dates. That variable was then used to list only the items with that date under the heading of the date.