Help, this programming condition always evaluate to true

Jangga said:

$bons = mysql_query($bonusreg) or die(mysql_error());
$dayzzee = $bons["bonus"];

Click to expand...

$bons = mysql_query($bonusreg) or die(mysql_error());
$bons = mysql_fetch_assoc($bons);
$dayzzee = $bons["bonus"];

Jangga said:

$bonusreg = "SELECT * FROM money WHERE username='$user'";
$bons = mysql_query($bonusreg) or die(mysql_error());
$dayzzee = $bons["bonus"];

if($dayzzee==0 && $duration=30){

My code here

}

Dayzzee & duration are numbers from my db. The problem I'm having is this. Please go through them.

1. If I use if($dayzzee==0 && $duration==30) it works but it always evaluate to TRUE if duration is 30 even when dayzzee is more than 0

2. If I use if($dayzzee='0' && $duration='30') it doesn't work at all

3. If I use if(!($dayzzee>0) && $duration=30) it is same as 1 above


Pls, I'm confused

Click to expand...

if($dayzzee===0 && $duration===30)

Jangga said:

$bons = mysql_query($bonusreg) or die(mysql_error());
$dayzzee = $bons["bonus"];

Click to expand...

chillerfx said:

I think you forget to convert queried results into an array.

Please use the following line before you assign $bons["bonus"] for $dayzzee.

$bons = mysql_fetch_assoc($bons);

Then check your actual condition.

Before use triple = sign, please confirm the data type what you get from your database.

Click to expand...

xrvel said:

I think it should be this

PHP:

$bons = mysql_query($bonusreg) or die(mysql_error());
$bons = mysql_fetch_assoc($bons);
$dayzzee = $bons["bonus"];

Click to expand...

Jangga said:

I got it working. But, I'm curious how do I confirm data type? Sometimes numbers in db appears as string or integer.... I just assume them to always be string but I know it can't always be

Click to expand...

/* If you would like to check with integer value convert the value into INT */
$dayzzee = (int)$bons["bonus"];
if($dayzzee===0 && $duration===30){
 // your code here
}

/* If you would like to check with Boolean value convert the value into BOOLEAN*/
$dayzzee = (bool) $bons["bonus"];
if($dayzzee===true && $duration===false){
 // your code here
}

chillerfx said:

You can't get the exact data type from the MySQL query's result. You have to convert your result into datatype, the one which you would like to check with '===' triple equal sign.

Example:

Code:

/* If you would like to check with integer value convert the value into INT */
$dayzzee = (int)$bons["bonus"];
if($dayzzee===0 && $duration===30){
 // your code here
}

/* If you would like to check with Boolean value convert the value into BOOLEAN*/
$dayzzee = (bool) $bons["bonus"];
if($dayzzee===true && $duration===false){
 // your code here
}

Click to expand...