Displaying fields with data only

[racrac]

How do you only display fields that have data? In this query, I'm pulling each row. Although, we don't have data in every field (see below)

Thanks!

if (isset($_GET["id"])) {

$id = $_GET["id"];
$sql = "SELECT * FROM xxxxxx WHERE xxxxxx_ID=$id";
$result = mysql_query($sql);        
$myrow = mysql_fetch_array($result);

}

?>

<h1><?php echo $myrow["XXXX_YYYYYY"]; ?></h1>
<h2><?php echo $myrow["ZZZZ_AAAA"]; ?></h2>
<p><b>Name: </b><?php echo $myrow["CCCC"]; ?></p>
<p><b>Another Name: </b><?php echo $myrow["BBBB"]; ?></p>

<p><b>Place: </b><?php echo $myrow["DDDD"] . "<br />" .
"&nbsp;" . $myrow["EEEE"] . "<br />" . "&nbsp;" . $myrow["FFFFF"] . ", " . $myrow["State"] . " " . $myrow["Zip"] . "<br />" . "&nbsp; <a href=\"http://" . $myrow["Directions"] . "\">Directions </a>" ?></p>
//We don't have Directions for every location, but don't want to show the link on every page

<p><b>Parking: </b><?php echo $myrow["Parking"]; ?></p>
//We don't have Parking for every location, but don't want to show "Parking".

[thorpe]

$sql = "SELECT * FROM xxxxxx WHERE xxxxxx_ID=$id AND Directions != NULL AND Parking != NULL";

[TobyRT]

I guess from this that you want to show as much information as possible, but if there are no directions, you don't want the 'directions' label, likewise 'Parking' label?

I'd use your existing $sql, but use php to determine what displays:

if (trim($myrow['directions']) !== '')
{
echo '<a href=\"http://' . $myrow["Directions"] . '\">Directions </a>';
}