putting all news items under one date!

<?

//Connections, etc.

$sql = "SELECT id, subject, type, YEAR(date) as year, DAYOFMONTH(date) as day, MONTHNAME(date) as month, user FROM $table_name WHERE type = "gaming" ORDER BY id DESC LIMIT 0,15";

$result = @mysql_query($sql,$connection) or die("Couldn't execute query.");

while ($row = mysql_fetch_array($result)){
$id = $row['id'];
$subject = $row['subject'];
$date = $row['date'];
$type = $row['type'];
$month_g = $row['month'];
$day_g = $row['day'];
$year_g = $row['year'];
$user = $row['user'];

$headlines .= "
<img src="http://www.gamequbed.com/images/blank.gif"><br><font face=Verdana><b>
<a name="newsid$view"><a href="http://www.gamequbed.com/view.php?type=$type&id=$id" class="blank" style="color: #ff9933">$subject</a></font></b><br><font face=Verdana color="#C0C0C0">$month_g $day_g, $year_g by $user</font><br>";

}
?>
<? echo "$headlines"; ?>

When I use this script, it displayes the news as...

$subject
$date

but when there are several items posted in one day, it's hard and confusing for my readers to see! ideally, this would be great...

$date
$subject
$subject

If anyone could help me out, it would be great! thanks

Basically what you need to do is each time you grab a row from the result set, see if it has already been displayed. In order to do this, you will need to make sure your result set is ordered by date and then stick the last date into a variable and then check each row to see if it matches the last date. Try something like this :

<?

//Connections, etc.

$sql = "SELECT id, subject, type, date, user FROM $table_name WHERE type = "gaming" ORDER BY date DESC, id DESC LIMIT 0,15";

$result = @mysql_query($sql,$connection) or die("Couldn't execute query.");

while ($row = mysql_fetch_array($result)){
$id = $row['id'];
$subject = $row['subject'];
$date = $row['date'];
$type = $row['type'];
$user = $row['user'];

if($lastdate <> $date) {
$headlines .= "<font face=Verdana color="#C0C0C0">" . date("m.d.y",strtotime($date)) . "</font><br>";
}

$headlines .= "<img src="http://www.gamequbed.com/images/blank.gif"><br>";
$headlines .= "<font face=Verdana><b><a name="newsid$view">"
$headlines .= "<a href="http://www.gamequbed.com/view.php?type=$type&id=$id" class="blank" style="color: #ff9933">$subject by $user</a>";
$headlines .= "</font></b><br>";
$lastdate = $date;
}
?>
<? echo "$headlines"; ?>


I haven't tested that, but it should give you the general idea on how to do it...

thanks alot matt! that really helped out alot.