hi,
Here is the ans
$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");
$b_date=substr($f1, -5,2);
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 ++;
}
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 ++;
}
else if($b_date=="12")
{
$bdecember ++;
/
}
else
{
echo $b_date."<br>";
}
$i++;
}</br>
Done to remove from unanswered list.