[RESOLVED] Dumb question on dynamic table

[dmacman1962]

Hi All,

This may be a dumb question, but I am going to post it anyway. 🙂

I have an SQL table I am looping thru and displaying the data in a dynamic table. My issue is it has an empty field the td does not display the table data border.

IE I do a ...

if(!$row['Initial']) {
	   echo "<td width=10>&nbsp;</td>";
	   } else {
	  echo "<td width=10>".$row['Initial']."</td>";
	  }

and when I check the source code, instead of a value of ..

<td>&nbsp;</td>

I get...

<td> </td>

Here is an example of my test page...

Notice the "Initial" table data cell formating.

The value in the SQL field is not "NULL" FYI.

I am missing something simple here.

I appreciate your help in advance,

Don

[stolzyboy]

try...

if($row['Initial'] == "") { 
       echo "<td width=10>&nbsp;</td>"; 
       } else { 
      echo "<td width=10>".$row['Initial']."</td>"; 
      }

sometimes, even if the var is NULL, it'll still BE there, so the NOT (!) won't work

hth,
stolzyboy

[NogDog]

Any difference if you do this...

if(trim($row['Initial']) === '') {
    echo "<td width=10>&nbsp;</td>";
} else {
    echo "<td width=10>".$row['Initial']."</td>";
}

...?

[dmacman1962]

I tried stolzyboy and nogdogs methods and nogdogs method worked. Stolzyboys did not.

Thanks for the help!

Don

[stolzyboy]

dmacman1962 wrote:

I tried stolzyboy and nogdogs methods and nogdogs method worked. Stolzyboys did not.

Thanks for the help!

Don

there was likely some "empty space" from the NULL that was still giving it a value, whether there was NO value in it or not, it still often sees it as a value, the trim "trimmed" off the blanks off of the variable therefore MAKING it empty

[anoopmail]

One
Two

[stolzyboy]

anoopmail wrote:

One
Two

okidokee