[Resolved] [Resolved] Echo date row once per date

Styles

Hi everyone. I have a fairly simple problem, but need some guidance.

I have a news section on my front page, and I want it to list the most recent articles. However, I only want it to print the date once per date - if there are more than one news items for, say, June 1 2005, I would only want it to print the date heading once, and then carry on again for any other dates.

Here is the code I'm working with:

$query = "SELECT title, LEFT(body, 200) AS b, category, DATE_FORMAT(add_date, '%M %e, %Y') AS d FROM news WHERE category='corpath' OR category='all' ORDER BY d DESC LIMIT 3";

if ($result == null) {
			echo "There is currently no news.";
		} else {
			while ($row = mysql_fetch_array ($result)) {
					echo "<h2 class=\"news\">" . $row['d'] . "</h2>";
					echo "<dl class=\"news\"><dt><a href=\"asdf\">" . $row['title'] . "</a>" . "</dt><dd><p>" . $row['b'] . "...</p></dd></dl>";
			}
		}

Thanks a lot.

planetsim

You'll need two queries. First to get the Date (formatted) The second to get the articles from that date. However you maybe able to get it done in one Query that which I am not sure.

Styles

I think I know what you mean, but how would I link the two queries together? What I mean is, how would the 2 queries know that the dates are the same or different?

If you have anymore thoughts, let me know.

leatherback

Hi,

Select the number items you need, ordered by date, as you have done now.

While you are retrieving the items, you test whether the date is the same as in the previous post:


$previous_date = "";

 while ($row = mysql_fetch_array ($result)) { 
  if($row[d] == 
$previous_date;
  }
else
  {
  echo $row[d];

$previous_date = $row[d];
  }
}

Styles

Fiddled with it a bit and it works like a charm.

Thanks so much folks.

leatherback

Hey Styles,

Nice to hear.

Can you mark this thread as solved? See link below...

Styles

No prob - thanks.