output from database, if statment

[a720]

I am still a newbie to databases. When my databsse outputs the results to the php page, if a field is empty the table is left empty. If there is information in the field a red block appears.
I would like to no how I can get a green block to appear if the field is empty. Can I use the else statment. If someone could show me some code it would really be appreciated.

<?

if ($jan1){ ?>

<img src="red_block.gif" width="20" height="20" align="absmiddle">

<? } ?>

[jburfield]

Sure....

You could do this:

<?

if ($jan1 == ""){
print("<img src=\"green_block.gi\f" width=\"20\" height=\"20\" align=\"absmiddle\">\n");
} ?>

Basically says if $jan1 is empty then show the gren block.

-- Jason