Loop question

[gj0519]

I currently have a script that I use a while loop to get my data.  What I am trying to figure out is a way to eliminate any records that are duplicates, like if 2 dates are the same to only show 1.

I have attached a png of what my output currently looks like.

Here is what my code is so far.

$message="";
while($list=mysqli_fetch_array($result)) {
   $date=$list['gm_date'];
   $time=$list['gm_time'];
   $gid=$list['gameid'];
   $fldname=$list['fld_name'];
   $tname=$list['team_name'];
   $rlname=$list['ref_lname'];
    $message.="<tr>
	<td>$date</td>
	<td>$time</td>
	<td>$gid</td>
	<td>$fldname</td>
	<td>$tname</td>
	<td>$rlname</td>
     </tr>";

Thanks,

GJ

 

[attachment deleted by admin]

[sdi126]

the best solution would be to limit the data returned from your mysql query have you tried using the keyword 'DISTINCT' in your query...just before the column 'gm_date'?

 

 

[Gighalen]

http://www.w3schools.com/sql/sql_distinct.asp

 

bow chica bow wow