How to test for a Null value in MySql

[Anon]

I want to be able to test a mysql database for a null value (as opposed to a blank or empty value) using php3. However, the code below does not seem to work and I have spent fruitless hours looking through the documentation and user groups for an answer. Someone else recently ask just this question but did not recieve an answer for this:

if (mysql_result($result,$i,"term") IS NULL) { do something ....}

thank you in advance

[Anon]

You won't be able to do this in php3. PHP 4 supports null datatypes however (I think they map to false, or may be an exact null).

I think the best way to do this in php3 is to do it database server side in your sql.

Tom