Show results of MySQL query only if field has a value

[twebman84]

Here's my entire code, it grabs data just fine. I want to only show the $nameNick result if that field has a value in the database. How can I accomplish that?

<?php
mysql_connect("localhost", "user", "password");
mysql_select_db("dbname");
 
$sql = mysql_query("SELECT * FROM master WHERE playerID = 'smithal01' ");
 
while($row = mysql_fetch_array($sql)){
  $playerID = $row['playerID'];
  $nameFirst = $row['nameFirst'];
  $nameLast = $row['nameLast'];
  $nameGiven = $row['nameGiven'];
  $nameNick = $row['nameNick'];
 
echo "<h1 class='playerTitle'>$nameFirst $nameLast</h1>";
echo "<p class='playerInfo'>$nameGiven $nameLast<br />$nameNick
</p>";
 
}
?>

Thanks in advance for taking the time to click through.

Edited February 19, 2014 by twebman84

[jairathnem]

Use mysql_num_rows() in if condition to check.