Click here to Skip to main content
15,898,371 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more:
Hi,
Actually i am using a simple if condition but getting some error
The code
PHP
$q="select * from cutomer_details";
$val=mysql_query($q,$con) or die("Mysql error".mysql_error());
$num= mysql_num_rows($val);
$i=0;
while($i<$num)
{
$f1=mysql_result($val,$i,"birth_date");
//echo $f1."<br/>";
//$b_date=intval(substr($f1, -5,2));
$b_date=substr($f1, -5,2);
//echo "<br/>".$b_date."<br/>";
if($b_date==01)
{
$bjan++;
//$bjan=intval($bjan);
//echo $bjan;
}
else if($b_date==02)
{
$bfeb ++;
//echo $bfeb;
}
else if($b_date==03)
{
$bmarch++;
//echo $bmarch;
}
else if($b_date==04)
{
$bapril ++;
//echo $bapril;
}
else if($b_date==05)
{
$bmay ++;
//echo $bmay;
}
else if($b_date==06)
{
$bjune ++;
//echo $bjune;
}
else if($b_date==07)
{
$bjuly ++;
//echo $bjuly;
}
else if($b_date==08)// loop not checking this
{
$baugust ++;
//echo $baugust;
}
else if($b_date==09)// loop not checking this
{
$bseptember ++;
//echo $bseptember;
}
else if($b_date==10)
{
$boctober ++;
//echo $boctober;
}
else if($b_date==11)
{
$bnovember ++;
//echo $bnovember;
}
else if($b_date==12)
{
$bdecember ++;
//echo $bdecember;
}
//else if($b_date==01)
else
{
echo $b_date."<br>"; // but here i am getting 08 and 09.

}


$i++;
}


Can any one suggest what is wrong in my code.

Solved
By just adding "".
Donot know why all other were working expect 08 and 09.

Thanks
Posted
Updated 27-May-13 20:40pm
v3
Comments
debasis behera 28-May-13 2:20am    
hii Rajesh
Try out compare with string in all your condition.ie if($b_date== '01').
But why need to wrire like this there must bu some better solutions.Please reply why you need to write this code.
[no name] 28-May-13 2:22am    
I just want to check how much birth days are there, months wise.
as you said using "" but why all other are working.
thanks
[no name] 28-May-13 2:28am    
I donot know why but its solved now.
Thanks

Answered only to remove from unanswered list - solved by OP.
 
Share this answer
 
hi,

Here is the ans
PHP
$q="select * from cutomer_details";
$val=mysql_query($q,$con) or die("Mysql error".mysql_error());
$num= mysql_num_rows($val);
$i=0;
while($i<$num)
{
$f1=mysql_result($val,$i,"birth_date");
//echo $f1."<br />";
//$b_date=intval(substr($f1, -5,2));
$b_date=substr($f1, -5,2);
//echo "<br />".$b_date."<br />";
if($b_date=="01")
{
$bjan++;

}
else if($b_date=="02")
{
$bfeb ++;
}
else if($b_date=="03")
{
$bmarch++;
}
else if($b_date=="04")
{
$bapril ++;

}
else if($b_date=="05")
{
$bmay ++;
//echo $bmay;
}
else if($b_date=="06")
{
$bjune ++;

}
else if($b_date=="07")
{
$bjuly ++;

}
else if($b_date=="08")
{
$baugust ++;

}
else if($b_date=="09")
{
$bseptember ++;

}
else if($b_date=="10")
{
$boctober ++;

}
else if($b_date=="11")
{
$bnovember ++;
//echo $bnovember;
}
else if($b_date=="12")
{
$bdecember ++;
/
}
//else if($b_date==01)
else
{
echo $b_date."<br>";

}


$i++;
}</br>


Done to remove from unanswered list.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900