note 22144 added to function.is-null

The above example is a little wrong. An empty value is not equivalent to null in mysql. To get not null in mysql use "... where column is not null" If you are doing a left join in mysql, no matched entry returns a null, where if you had a matched entry and were asking about a text field, '' might match, so != '' is different than is not null -- http://www.php.net/manual/en/function.is-null.php http://master.php.net/manage/user-notes.php?action=edit+22144 http://master.php.net/manage/user-notes.php?action=delete+22144 http://master.php.net/manage/user-notes.php?action=reject+22144