不要显示空格

Question

I use an SQL query from PHP code to display fields of a database on a website. Is there a way to delete the blank spaces (whitespaces) in the output of empty (NULL) fields?

Here is my code:

<?php 
    $sql = "SELECT * FROM dining ORDER BY date DESC LIMIT 0, 3";

    $dining = new Database($sql);
    while($dining->results()){

    echo "          
                    <span class='date'>". date("F jS, Y", strtotime($dining->date)) ."</span>
<h3>&nbsp;$dining->title</h3>
<h4>&nbsp;$dining->Comforts</h4> 
&nbsp;$dining->com1<br/>
&nbsp;$dining->com2<br/>
&nbsp;$dining->com3<br/>
&nbsp;$dining->com4<br/>
&nbsp;$dining->com5<br/>
&nbsp;$dining->com6<br/>
<h4>&nbsp;$dining->Breakers</h4>
&nbsp;$dining->break1<br/>
&nbsp;$dining->break2<br/>
<h4>&nbsp;$dining->Wild</h4>
&nbsp;$dining->wild1<br/>
&nbsp;$dining->wild2<br/>
<h4>&nbsp;$dining->Tureens</h4>
&nbsp;$dining->tur1<br/>
&nbsp;$dining->tur2<br/>
&nbsp;$dining->tur3<br/>
<h4>&nbsp;$dining->Desserts</h4>
&nbsp;$dining->des1<br/>
&nbsp;$dining->des2<br/>
&nbsp;$dining->des3<br/>
&nbsp;$dining->des4<br/><br/>
";  
}
?>

Answer 1

If you want to suppress blank values, you'll have to test each value individually to decide if it should be output or not, e.g.

if (strlen($dining->des1) > 0) {
   echo "&nbsp;{$dining->des1}<br />";
}