Display only when DB is filled?

[Skipjackrick]

So,

 

I have this contest where when a user catches a fish they enter the size of the fish and this small snippet of code is used to display the data of the largest fish caught.

 

Well, the contest is just starting and the page displays blank data.

 

Is there a way to display the result only when the database is filled with an entry?  I would like for it to be blank until an entry is made into the DB.  It works great otherwise.

 

$query_trout = "SELECT species_id, team_id, MAX(length)
	FROM submit
	WHERE species_id=2
	GROUP BY team_id";

$result5 = mysql_query($query_trout) or die(mysql_error());

while($row = mysql_fetch_array($result5))
{
$team_id = $row['team_id'];
$species_id = $row['species_id'];
$trout = $row['MAX(length)'];

//get team's name from team table
get_team_name($team_id);
get_species($species_id);

}
$trout_bonus .=<<<EOD
<tr>
	<td align='center'>$speciesname</td>
	<td align='center'>$teamname</td>
	<td align='center'>$trout"</td>
</tr>
EOD;

[pocobueno1388]

Try

 

<?php

$query_trout = "SELECT species_id, team_id, MAX(length)
	FROM submit
	WHERE species_id=2
	GROUP BY team_id";

$result5 = mysql_query($query_trout) or die(mysql_error());

if (mysql_num_rows($result5) > 0){

while($row = mysql_fetch_array($result5))
{
$team_id = $row['team_id'];
$species_id = $row['species_id'];
$trout = $row['MAX(length)'];

//get team's name from team table
get_team_name($team_id);
get_species($species_id);

}
$trout_bonus .=<<<EOD
<tr>
	<td align='center'>$speciesname</td>
	<td align='center'>$teamname</td>
	<td align='center'>$trout"</td>
</tr>
EOD;

} else {
   echo "No fish caught yet.";
}