Jump to content

[SOLVED] Showing blank for NULL values


bravo14

Recommended Posts

Hi

 

If you have a look at www.yardleyheroes.co.uk/fixtures.php you will see a list of fixtures, however the results are empty in the database, but they show as a zero

$result = mysql_query('SELECT * FROM `fixtures` ORDER BY `date`', $con) or die(mysql_error());
if(mysql_num_rows($result) < 1) 
{ 
   echo('<tr class="profiletext"><td colspan="7">Sorry, no results were found.</td></tr>'); 
} 
else 
{ 
   while($row = mysql_fetch_array($result))
    {
if ($row[HomeAway]=="Home") {
echo ('<tr><td>'.$row[Date].'</td><td><b>Yardley</b></td>');
echo ('<td align="center">'.$row[yardley_goals].'-'.$row[opposition_goals].'</td><td>'.$row[Opposition].'</td>');
echo ('<td></td><td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?match_id='.$row[match_id].'">View Fines</a></td></tr>');
       }

else{

echo ('<tr><td>'.$row[Date].'</td><td>'.$row[Opposition].'</td>');
echo ('<td align="center">'.$row[opposition_goals].'-'.$row[yardley_goals].'</td><td><b>Yardley</b></td>');
echo ('<td></td><td></td><td><a href="http://www.yardleyheroes.co.uk/matchfines.php?'.$row[match_id].'">View Fines<a></td></tr>');
        }
}
}
mysql_close($con);
?>

 

How do I show a blank field if the value sin the database are blank?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.