grouping posts by date

[newb]

i have a problem..my posts are showing up like this:

 

July 6:

post message

 

July 6:

post message

 

July 6:

post message

 

im trying to get it like this:

 

July 6:

post message

post message

post message

 

how do i group them like this in all in one post?

[msaz87]

Show some code

[shortysbest]

In your mysql query where you're echoing out the posts, have you tried adding "GROUP BY date"

 

date would be what ever the column in your database with the date is called

[newb]

i dont think that works because in my database there is stored UNIX timestamps...

[Pikachu2000]

Not certain, but the MySQL FROM_UNIXTIME() function might be able to help you sort this out.

[newb]

i am trying to acheive this:

http://www.breakfastpolitics.com/

 

can someone help me out please.. :-\

[shortysbest]

i am trying to acheive this:

http://www.breakfastpolitics.com/

 

can someone help me out please.. :-\

post your code please?

[newb]

$query = mysql_query("SELECT * FROM av_items  ORDER BY av_items.date DESC LIMIT 20");

	while ($row = mysql_fetch_assoc($query)) {
		$id = $row['id'];
		$date = $row['date'];
$message = $row['message'];

		$entry_date = date("Ymd", $date);
		if ($entry_date !== $called_date) {



		echo '<h1 class="topic">'.av_date($date) .'</h1>';
echo $message;
$called_date=$entry_date;
}
}

[shortysbest]

 

Have you tried this? :

 

$query = mysql_query("SELECT * FROM av_items  GROUP BY month(date) ORDER BY av_items.date DESC LIMIT 20");

	while ($row = mysql_fetch_assoc($query)) {
		$id = $row['id'];
		$date = $row['date'];
$message = $row['message'];

		$entry_date = date("Ymd", $date);
		if ($entry_date !== $called_date) {



		echo '<h1 class="topic">'.av_date($date) .'</h1>';
echo $message;
$called_date=$entry_date;
}
}

[newb]

im trying to group by day not month..didnt help

[shortysbest]

im trying to group by day not month..didnt help

whoops sorry, replace month with day.

[newb]

didnt change anything

[sasa]

move line

echo $message;

after if block

[newb]

nope. anyone?

[sasa]

try

$query = mysql_query("SELECT * FROM av_items  ORDER BY av_items.date DESC LIMIT 20"); //remove GROUP BY part

	while ($row = mysql_fetch_assoc($query)) {
		$id = $row['id'];
		$date = $row['date'];
                                          $message = $row['message'];

		$entry_date = date("Ymd", $date);
		if ($entry_date !== $called_date) {



		echo '<h1 class="topic">'.av_date($date) .'</h1>';
//echo $message;
$called_date=$entry_date;
}echo $message, "<br />\n";
}