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.
