hi all i have this SQLite3 query SELECT Count(*) FROM forums WHERE post_delay!=IS NULL PHP: it should not count rows with post_delay if it was empty... i have no idea what to do to make this work.. i tried only NULL, but someone told me that using only NULL means false...its not empty record.. any ideas?
Besides (this is from a MySQL background though), you can't do != IS NULL or even = IS NULL , since "IS NULL" is the condition itself For example to do what you were trying to do: post_delay IS NOT NULL that would be the whole condition, but a blank or space saved in a field still counts as content.