blank fields
Posted: Wed Dec 18, 2002 1:57 am
hi people!
i have the following code:

i have the following code:
the result looks like this:if ($CNOMEN == "")
{$CNOMEN = '%';}
if ($NOMRL == "")
{$NOMRL = '%';}
// Change this to fit your database
$result = mysql_query ("SELECT * FROM friarsofmconv
WHERE CNOMEN LIKE '%$CNOMEN%'
AND NOMRL LIKE '%$NOMRL%'
",$conn);
if ($row = mysql_fetch_array($result)) {
do {
PRINT "<b>Surname:</b> ";
print $row["CNOMEN"];
print ("<br>");
PRINT "<b>Name:</b> ";
print $row["NOMRL"];
print ("<br>");
PRINT "<b>Province/Custody:</b>";
print $row["PROVEN"];
print ("<br>");
PRINT "<b>Ordination:</b>";
print $row["SACDAT1"];
print ("<p>");
print ("<p>");
} while($row = mysql_fetch_array($result));
} else {print "Sorry, no records were found!";}
?>
since the ordination field is empty on the database i would like it to appear:Surname: Cubacub
Name: Bernard M.
Province/Custody: Provincial Custody (Nap.)
Ordination:
what code do i need to add in order for it not to be printed on the result. thanks.Surname: Cubacub
Name: Bernard M.
Province/Custody: Provincial Custody (Nap.)