Date grouping

[zenin]

I want my rows in the database to appear like this:

2005-10-10
row 1
row 2
row 3
row 4

2005-10-09
row 5
row 6
row 7
row 8

2005-10-08
row 9
row 10
row 11
row 12

etc

The question is how do i do that? All my rows in my database have a date...some have the same date couse I inserted them on the same day. Problem is how do i group those who have the same date?

Thx in advance

[_RL_Ian]

zenin wrote:

I want my rows in the database to appear like this:

2005-10-10
row 1
row 2
row 3
row 4

2005-10-09
row 5
row 6
row 7
row 8

2005-10-08
row 9
row 10
row 11
row 12

etc

The question is how do i do that? All my rows in my database have a date...some have the same date couse I inserted them on the same day. Problem is how do i group those who have the same date?

Thx in advance

Here is a real basic idea of what you're trying to do. I just wrote it in here and didn't test it, but you should get the idea:

<?php
$sql = "SELECT * FROM table ORDER BY date DESC";
$result = mysql_query($sql);


while ($row = mysql_fetch_array($result))
{
	if ($last_date != $row['date'])
	{
		echo("<br />" . $row['date'] . "<br />");
	}

echo("row info");

$last_date = $row['date'];
}
?>