MySQL empty or null values

[alexaugot]

Hi,

I'm writing this script that goes into a database and sends a query, and grabs the result id, etc, etc, etc - normal procedure.

My problem is sometimes null or empty vales will come out of the SQL statement, and when it prints to HTML it screws up the UI (td borders won't be drawn, so they'll look white, like the background, instead of black like they should).

So I tried to do this - >

while($row = mysql_fetch_array($someResults)){
// ......... Some stuff
for($x=0;$x<count($fields);$x++){
if(!(isset($row[$x]))){$temp = "&nbsp; 2";}
else{$temp = $row[$x];}

    // CreateTd() is just a function that I wrote
    // to handle HTML creation data.

createTd("*","right","top",$table_css[$z],$tenp . " " . $row[$x]);
		$y++;
		}

// ............... etc,
}

But using that if statement doesn't work, so I'm probably looking for something that isn't there. Anyone knows what MySQL spits out when it encounters nothing?

-Alex

[alexaugot]

Whoops,

Small error when I typed in the code -

createTd("*","right","top",$table_css[$z],<b>$tenp</b> . " " . $row[$x]);

should be

createTd("*","right","top",$table_css[$z],<b>$temp</b> . " " . $row[$x]);

The typo isn't the reason it's not working :-)

-Alex

[[deleted]]

Results from the database are allways 'set', they just contain a zero-length string

instead of
if (!isset($row[$x]))

use
if ($row[$x]!='')