intente lo siguiente, pero no resulta
Código PHP:
for ($i=0; $i<12; $i++){
$x = $i+1;
if ($i<9){
$fec1 = date("Y-0$x-01 00:00:00");
$fec2 = date("Y-0$x-31 00:00:00");
echo $fec1." ".$fec2."<br>";
$result = mysql_query("SELECT * FROM md5 WHERE fecha BETWEEN '$fec1' AND '$fec2' Order by 'fecha' DESC") or die ("no se conecto");
while(mysql_fetch_row($result)){
$j++;
}
echo $j."<br>";
}else{
$fec1 = date("Y-$x-01 00:00:00");
$fec2 = date("Y-$x-31 00:00:00");
echo $fec1." ".$fec2."<br>";
$result = mysql_query("SELECT * FROM md5 WHERE fecha BETWEEN '$fec1' AND '$fec2' Order by 'fecha' DESC") or die ("no se conecto");
while(mysql_fetch_row($result)){
$j++;
}
echo $j."<br>";
}
}