how to test if SELECT returns null

[Anon]

Hi,

I am using php and MySQl. I tried to display the output of a select statement in a html table. The table border was missing wherever the value of the record returned from MySql is "" or null. How could we test if MySql returns null or ""? The code I am using is like this:

$result = mysql_query($sql, $linkId);
$row = mysql_fetch_row($result);
foreach($row as $field)
{
//PHP never goes into the if statement
if(empty($field)){
$field = " ";
}
print "<td>$field</td>";
}

Could anybody help me out?

[shastry]

Hi,
Put the below code before printing result Set.
$result=mysql_query("urQuery");
$numrows = mysql_num_rows($result);
// Check To See The Number Of results Returned
if ($numrows == 0)
{
print "No Results";
exit();
}

--Shastry

[Anon]

Do it like this:

if(empty($field)){
$field = "&nbsp;";
}
print "<td>$field</td>";
}