NULL or is it???

cheese

Good afternoon all,

Can anyone tell me why this doesn't work. I have checked in the SQL2000 database and the item I am returning comes up as <NULL>.......

$col3 = odbc_result($row,3);

print "<table width=400 CLASS=NOBORDER align=center>";
print "<tr bgcolor=#A3A4C1><td align=center >Item</td><td align=center>Details</td></tr>";

if ($col3==NULL) {
print "<td bgcolor=#FF0000>Department Code</TD>";
print "<td bgcolor=#FF0000>";
print "NOT ENTERED!!";
print "</TD></TR><TR>";
}
else {
print "<td bgcolor=#B2B3F0>Department Code</TD>";
print "<td bgcolor=#B2B3F0>";
print $col3;
print "</TD></TR><TR>";
}

print "</TABLE>";

Thanks in advance for any assistance.

Neil.

dalecosp

Are you certain of the value of $row?

Do you have a database monitor/client that you can test your query with?

OhLordy

try just doing (!$col3)
HTH
Rob

barand

... or

is_null($col3)

cheese

I have checked and it says it is a NULL, which is also what the SQL2000 database says it is.......

Really all I wanted to do was only print rows in the table when there is some useful data in it.

I have been through the above listing loads of times, but I still can't see why it does not repond correctly.

Regards,

Neil.

barand

You couls filter them out in your original query

... WHERE columnname is not NULL ...

Note you can't do column <> NULL, or column = NULL, as NULL isn't a value you do an equality test - it's an absence of a value.

Hence if (is_null($col3))

hth

cheese

Good afternoon all,

I tried if (is_null($col3)) but that hasn't done the trick.

I had already looked at returning the rows that were not null from the select query, but that gave me a table format problem.

Well, I guess I will have to leave them blank for the time being, unless anyone can come up with another idea.

All the best for the weekend.

Neil.