I&#039;ve got a page that I want to display seven days worth of journal entries. My SQL string searches for dates between Now-7 and Now. It almost works, but if there was not an entry for one of the last seven days, it will only display six days of entries.<BR><BR>What&#039;s the best way to iterate through the results, and see how many days in the last week have entries? I thought about putting the dates into an array, searching for duplicates, getting a final count, and then modifying the search if there aren&#039;t seven days, but even this seems bloated. Keep in mind that any given day can have more than one entry, too. Any help is much appreciated. Code available if necessary. Thanks much.