embarrasing problem

rulian

I've been doing php for 1 and a half years, and I cant figure this out:

I have a simple table with comments, fields are:

Date | User | Comment

here is what I want to do, i want to query all the comments, and I want to do is group all comments made on the same day, as to display:

The Date:
Comment 1
Comment 2:
Comment 3:

The Second Date:
Comment 1:
Comment 2:

here is the trick, i want to do this all in one query so not to take up precious loading time. The problem is the only way I can think of doing this is to query the table, ask for each disctinct date, and then query the table again for each disctinct date for their comments.

rrijnders

Just use ORDER BY to retrieve the rows in date sequence; the rest is done in your code:

Here is some non-db-specific pseudocode:

$breakdate = 0;
while ($row = get_row($result)) {
  if ($row['date'] <> $breakdate {
    $breakdate = $row['date'];
    print "<br><strong>Date: " . $breakdate . "</strong><br>";
  }
  print $row['comment'] . "<br>";
}

michael

select comments from mytable where date=DATE1 or date=DATE2 order by date

That would allow you to pull comments only from mytable and would sort them by date.

So you would print each of the comment groups, and when you notice the date change, put in your line break, add a new title line in your page, bobs your uncle, your done.