PHP - Need help displaying data by time

[Bradderzz08]

Hello, thanks for taking your time to help me out.
Please can you help me with this code 🙂

I want it to display the data like this:

-TODAYS-DATE-
NEWS
NEWS
-YESTERDAYS-DATE-
NEWS
NEWS

But at the minute it will only display like;

-DATE-
NEWS
-DATE-
NEWS
-DATE-
NEWS

<table width=500 cellspacing=1 cellpadding=1 border=0 bordercolor="black" class="black3" align="center">
<tr>
<td class="header">Game Updates</td>
</tr>
<?php
while ($arr = mysql_fetch_array($que)){
$update = $arr['update'];
$type = $arr['type'];
$by = $arr['updator'];
$d = $arr['date'];

$date=ConvertDate($d);

?>
<tr class="title">
<td><? print $date ?></td>
</tr>

<tr class="text">
<td>
<table class="black" width="100%"> <tr class="text">
<td width="1%" align="center"><? print $type ?></td>
<td align="left"><? print $update ?></td>
<td align="center"><? print $by ?></td>
</tr>

</table>
<? } ?>
</tr>
</table>

[dagon]

in the while loop, keep track of the date, when it changes you output it, when it doesn't, you don't.

[Bradderzz08]

Can you give me a pointer where to look to sort this out?

I want it to display all "Updates" posted on the same day.

An example;

| Game Updates |

| Tuesday 16th December 2010 |
| [TYPE] | [UPDATE] | | [BY] |
|---------------------------------------------------
| Wednesday 15th December 2010 |
| [TYPE] | [UPDATE] | | [BY] |
|---------------------------------------------------

[dagon]

this should get you started:

//start of table

while ($arr = mysql_fetch_array($que)){

if(echo $arr['date'] != $temp_date){
        echo $arr['date'];
       $temp_date=$arr['date'];
}
       echo "news fields";
} 

//end of table

[Bradderzz08]

Still cannot get it to work, sorry about this.. Please can you explain?
Thanks so much for your time aswell!

<table width=500 cellspacing=1 cellpadding=1 border=0 bordercolor="black" class="black3" align="center">
<tr>
<td class="header">Game Updates</td>
</tr>
<?php
while ($arr = mysql_fetch_array($que)){
$update = $arr['update'];
$type = $arr['type'];
$by = $arr['updator'];
$d = $arr['date'];
$today = gmdate('Y-m-d');
$date=ConvertDate($d);

if( $arr['date'] != $temp_date){
$arr['date'];
$temp_date=$arr['date'];
} ?>
<tr class="title">
<td><? print $date ?></td>
</tr>
<? }
if( $arr['date'] = $temp_date){
$arr['date'];
$temp_date=$arr['date'];
} ?>
<tr class="text">
<td><table class="black" width="100&#37;">
<tr class="text">
<td width="1%" align="center"><? print $type ?></td>
<td align="left"><? print $update ?></td>
<td align="center"><? print $by ?></td>
</tr>
</table>
</table>
</td>
</tr>

[Bradderzz08]

I would like it to display like this, but I just cannot make them go into the same "dates"
It just keeps displaying

DATE
NEWS
DATE
NEWS

Here is what I would like it to look like
http://img813.imageshack.us/img813/4707/gameupdates.png

[dagon]

its not 100% but you should be able to fix any issues.

<table width=500 cellspacing=1 cellpadding=1 border=0
	bordercolor="black" class="black3" align="center">
	<tr>
		<td class="header">Game Updates</td>
	</tr>
<?php
while ( $arr = mysql_fetch_array($que) ){
	$update = $arr['update'];
	$type = $arr['type'];
	$by = $arr['updator'];
	$d = $arr['date'];
	$today = gmdate('Y-m-d');
	$date = ConvertDate($d);


if($date !=$temp_date){
	echo '<tr class="title">
	<td>'.$date.'</td>
</tr>';
	$temp_date = $date;
}

?>


<tr class="text">
	<td>
	<table class="black" width="100%">
		<tr class="text">
			<td width="1%" align="center"><?php
echo $type;
?></td>
			<td align="left"><?php
echo $update;
?></td>
			<td align="center"><?php
echo $by;
?></td>
		</tr>
	</table>
<?php

}
?>


</table>
</td>
</tr>

[Bradderzz08]

Thanks so much, this is now resolved! - Thanks for your time 🙂
<3

[Bradderzz08]

Thanks again, but I need one more bit of help :$ - Just to do with the last part of the code.

<?php
echo $by;
?></td>
</tr>
</table>

I want to know if there is a way to make </table> apper if there is no updates left to display from that date.
The HTML output at the moment is;

<tr class="title">
<td>Thursday 16 December 2010</td>
</tr> <tr class="text">
<td>
<table class="black" width="100&#37;">

	            <tr class="text">
            <td width="1%"><font color=green>[Feature]</td>
            <td>Just a quick test - News</td>
            <td><font color=blue>Bradderzz08</td></tr>

</table>

        <tr class="text">
            <td width="1%"><font color=green>[Feature]</td>

            <td>Blah Blah Blah News</td>
            <td><font color=blue>Bradderzz08</td></tr>

</table>

When it I would like it to be;

<tr class="title">
<td>Thursday 16 December 2010</td>
</tr> <tr class="text">
<td>
<table class="black" width="100%">

	            <tr class="text">
            <td width="1%"><font color=green>[Feature]</td>
            <td>Just a quick test - News</td>
            <td><font color=blue>Bradderzz08</td></tr>

        <tr class="text">
            <td width="1%"><font color=green>[Feature]</td>

            <td>Blah Blah Blah News</td>
            <td><font color=blue>Bradderzz08</td></tr>

</table>

[Bradderzz08]

Anyone help please?