[SOLVED] ENUM and IF's

[anser316]

Hi. This is a column and its constraints which i have added in a table on mysql

 

exemption_type	ENUM('NO','YES') NOT NULL,

 

The default value is 'NO' which i intend it to be.

I insert the exemption_type on a php form, and it shows that it is inserted. On a linked php form i have:

if ($row[exemption_type]=Yes){
some code
}
else if($row[exemption_type]=No){
some code
}
else
echo "Error";

 

For some reason it always executes the first if statement, whether its Yes or No. I would appreciate some help, thanks.

[digitalgod]

that's because you're using the assignment operator, you should use "==" without the quotes, you should also add quotes to Yes and No

 

so your code should look like this

 

if ($row[exemption_type]=='Yes'){
some code
}
else if($row[exemption_type]=='No'){
some code
}
else
echo "Error";

 

[anser316]

thanks that worked, i also had to change it to from Yes to YES, so i guess enum is case sensitive