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
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