Checking for Null

I have a a field called “activation_code” in my Members table.

Once a Visitor activates his/her account - and becomes a Member - the value in this field is erased.

What is the proper way to check this field to see if it is Null?

Debbie

what do you mean by ‘erased’?

You can try

where activation_code is null

or

where activation_code is not null

Nulled out.


$q = "UPDATE member
	SET activation_code=NULL,
		activated_on=NOW(),
		updated_on=NOW()
	WHERE (email=? AND activation_code=?)
	LIMIT 1";

Debbie