Loop through and enter <br /> when new day

[defroster]

Hello, I have a database where each post has a  corresponding date/time:

 

DATABASE

Post 1. 2012-08-12 18:20:15

Post 2. 2012-08-12 16:30:00

Post 3. 2012-08-11 18:20:15

Post 4. 2012-08-10 13:20:30

 

When looping through and showing the results I want to put a <br /><br /> when there is a new day , but how do I do this?

 

I can only separate them if the the exact time is same on all posts...

if ($row['date'] != $previousloopdate){
echo "<br /><br />";
}

Thanks

[Christian F.]

I recommend looking into the strtotime () and date () functions in the PHP manual, should give you exactly what you want.

[defroster]

Thanks for answer. I have been looking into these but cannot fully grasp it.. is there any way I can use code like this? But instead specify if the date is the same, regardless of time..

if ($row['date'] != $previousloopdate){
echo "<br /><br />";
}

[scootstah]

Not tested, but try something like:

while($row = mysql_fetch_assoc($result)) {
$current = date('d', strtotime($row['date']));

if (isset($previous) && $previous != $current) {
	echo '<br />';
}

$previos = $current;
}

[defroster]

Thanks a million! You are the man