Hiding returned empty (NULL) fields?

[sickchilly]

Man, it must be brain fart day... I've got this code here that lists records from a database. What I want to do is hide a certain "bit" of code or not "print" it if the field is empty or NULL.

<?
print"<br><hr noshade size=\"1\" width=\"100%\">";
// links within category

$resultl = mysql_query("SELECT *, DATE_FORMAT(Date, '%D %M %Y') AS Date FROM dir_links WHERE CatID=$id AND Approved='1'");
$listl = @mysql_num_rows($resultl);
	if ($listl!='NULL') {
	print"<div class=\"dirmain\"><b>$links</b> - $catname ($listl)</div><br>";
	print"<table width=\"100%\" border=\"$border\" $style><tr><td>";
	while ($il < $listl) {
		$rowl = mysql_fetch_array($resultl);
			$namel = $rowl["Name"];
			$idl = $rowl["LinkID"];
			$ura = $rowl["URL"];
			$descl = $rowl["Description"];
			$datel = $rowl["Date"];
			$hitsl = $rowl["Hits"];
			$contactl = $rowl["Contact"];
			$email = $rowl["Email"];
			$addrl = $rowl["Address"];
			$cityl = $rowl["City"];
			$statel = $rowl["State"];
			$zipl = $rowl["Zip"];
			$countryl = $rowl["Country"];
			$phonel = $rowl["Phone"];
			$faxl = $rowl["Fax"];
	print"<a href=\"./dirinc/click.php?url=$ura&id=$idl\" class=\"dirlist\" target=\"new\">$namel</a><br>";
	print"<div class=\"dirlist\">$contactl&nbsp;-&nbsp;<a href=\"mailto:$email\">$email</a></div>";
	print"<div class=\"details\">$addrl</div>";
	print"<div class=\"details\">$cityl,&nbsp;$statel&nbsp;$zipl&nbsp;$countryl</div>";
	print"<div class=\"details\">Phone:&nbsp;$phonel&nbsp;&nbsp;Fax:&nbsp;$faxl</div>";
	print"<div class=\"link\">$ura&nbsp;&nbsp;$hittxt:&nbsp;$hitsl</div>";
	print"<div class=\"details\">$descl</div>";
	print"<br>";
	$il++;
	}
print"</td></tr></table>";
print"<hr noshade size=\"1\" width=\"100%\">";
}
else {
}
?>

So for example, if $cityl were empty, I'd like "$cityl, " to be hidden or not printed. I'm open to restructering this code if necessary. Thanks, Trent.

[PHPdev]

Well you are going to need to use IF statements, there are several ways you can accomplish your goal...

one way is

.
.
.
print"<div class=\"details\">";
If (!is_null($city)) {
    print($city);
}

if (!is_null($state)) {
    print($state);
}
.
.
.

PHPdev

[sickchilly]

Excellent, worked like a charm. Thanks!