[Resolved] Display if in database, don't if not....

[charles256]

I want the Official rules to post only if there is a link
in the database to post. Otherwise do not post a link,
just plain text or nothing at all. Here is the part of
code I am working on:

while ($row = mysql_fetch_array($results))
{

print "<tr>";
print "<td width=\"50%\"><a href=\"" . $row['sur_link']. "\">" . $row['sur_name'] . "</a><br>";
print "" . $row['sur_description'] . "</td>";
print "<td width=\"10%\"><b><font size=\"1\">&nbsp;" . $row['sur_entry'] . "</font></b></td>";
print "<td width=\"10%\"><b><font size=\"1\">End Date<br>" . $row['sur_enddate'] . "</font></b></td>";
print "<td width=\"20%\"><a href=\"" . $row['sur_ruleslink']. "\"><font size=\"1\">Official Rules</font></td>";
print "</tr></table><br><br>";

}

thanks in advance
charles

[tommynanda]

while ($row = mysql_fetch_array($results)) 
{ 
if($row['sur_ruleslink']!="")
   $link = "<a href=\" $row['sur_ruleslink'] \">";
else
  $link = "No Link";
print "<tr>"; 
print "<td width=\"50%\"><a href=\"" . $row['sur_link']. "\">" . $row['sur_name'] . "</a><br>"; 
print "" . $row['sur_description'] . "</td>"; 
print "<td width=\"10%\"><b><font size=\"1\">&nbsp;" . $row['sur_entry'] . "</font></b></td>"; 
print "<td width=\"10%\"><b><font size=\"1\">End Date<br>" . $row['sur_enddate'] . "</font></b></td>"; 
print "<td width=\"20%\">$link<font size=\"1\">Official Rules</font></td>"; 
print "</tr></table><br><br>"; 

}

Good Luck
TommYNandA

[Tracer]

what about using

if(!empty$row[rules_link])) {
echo "$row[rules_link]"
}

[charles256]

that worked perfect, tommynanda
!!!!!!! thank you