How to check if database field is empty

[AdRock]

I have a field in my database which is used to hold the name of an image

What i want to do is have an if statement so if that field has got an image name in it then do this code

[code]echo "<div id='right'><h3>".strtoupper($code['title'])."</h3><p class='style3' style='text-align:left'><i>Date added: ".$code['date']."</i></p><p class='style3'><img src=images/".$code['photo']." align='right' class='right'>".nl2br($code['content'])."</p><br></div>\n";[/code]

if the field is empty do this code

[code]echo "<div id='right'><h3>".strtoupper($code['title'])."</h3><p class='style3' style='text-align:left'><i>Date added: ".$code['date']."</i></p><p class='style3'>".nl2br($code['content'])."</p><br></div>\n";[/code]

How do i check if the field is empty?

[sanfly]

Something like this should do it:

[code=php:0]
if(!$code['photo']){
do this
}
else{
do that
}
[/code]

the ! means "if the condition is false"

you could also use empty()

if(empty($code['photo'])){
do this
}
else{
do that
}
[/code]