Don't display image if null

[jonw118]

Have a very simple question, and my attempts haven't worked... what do I need to add to this code to make it not display an image if there isn't one uploaded? Right now it shows a broken image.

 

<?
$sql="select image from inputinfo where id='$id'";
$rez=mysql_query($sql,$dblnk);
$row=mysql_fetch_array($rez);
echo "<img src='admin/{$row['image']}' />";
?>

 

Thanks for any help!

[darkfreaks]

<?php
$sql="select image from inputinfo where id='$id'";
$rez=mysql_query($sql,$dblnk);
$row=mysql_fetch_array($rez);
if($row['image']=="NULL" && $row['image']=="") {}else{
echo "<img src='admin/{$row['image']}' />";
}
?>

[Sesquipedalian]

Something similar should also suffice:

<?
$sql="select image from inputinfo where id='$id'";
$rez=mysql_query($sql,$dblnk);
if ($rez) {
    $row=mysql_fetch_array($rez);
    echo "<img src='admin/{$row['image']}' />";
}
?>