Seperate each day by a space not each game

[artosousa]

Hey guys, Im working on a hockey leagues site and i want to each day to be separated, instead i have each game separated...http://hockeywithballs.com/schedule.php you can see there is a break between each game and i want it organized by day...so having a break to divide each day not game like stated above... Here is the code...

 

<?php
		require_once("Connections/connect.php");
		$myshows = mysql_query("SELECT schedule_id, schedule_date, schedule_time, schedule_location, schedule_teamone, schedule_teamtwo FROM tbl_schedule WHERE schedule_date >= CURRENT_DATE ORDER BY schedule_id ASC ");

		while ($row=mysql_fetch_array($myshows)){
		print "
<tr bgcolor='#666666'><td width='150'>".date('l F jS', strtotime($row['schedule_date']))."</td><td width='100'>".$row['schedule_time']."</td><td width='200'>".$row['schedule_location']."</td><td width='150'>".$row['schedule_teamone']."</td><td width='111' align='center'>V.S</td><td width='150'>".$row['schedule_teamtwo']."</td></tr><tr><td><br />
</td></tr>";
		}
		$none = mysql_query("SELECT schedule_id, schedule_date, schedule_time, schedule_location, schedule_teamone, schedule_teamtwo FROM tbl_schedule WHERE schedule_date >= CURRENT_DATE ORDER BY schedule_id ASC ");
		$gone=mysql_fetch_array($none);
		if ($gone==""){
		echo "<tr><td align='center' colspan='3' rowspan='2'><span class='style3'>No Upcoming Shows</span></td></tr>";
		}
		?>

 

[fenway]

If there's northing wrong with mysql query, then this isn't a mysql question.

[artosousa]

where should i put it than?