if null do not display

[bluns]

heres an example of part of my script, echoing data from my database with a break after each data from a table

<?php
echo "$doll[haircolor]<br/> $doll[height]<br/>
?>

If i enter a null value, it will still display the breaks 🙁

how can i not include the break if the value stored in my database is null? Otherwise it looks like this

data
data
data

data

data
data

if you know what i mean 😉

[_off_axis_]

just check to see if the value is null or not and echo it if it isn't and do nothing if it is

if((!empty($doll[haircolor])) AND (!empty($doll[height]))){
echo "$doll[haircolor]<br>$doll[height]<br>";
}

[Sxooter]

Can you just not select the null rows?

select * from table where field is not null