between ile yapabilirsin.


<?php 
----mysql baglantisi---

$bugun= date("Y-m-d");
$yenitarih = strtotime('-90 day',strtotime($bugun));
$yenitarih = date('Y-m-d' ,$yenitarih );

$sql = "select fatura,id,count(*)  as toplam from faturalar WHERE date_format( tarih, '%Y-%c-%d' ) between '$yenitarih' and '$bugun' group by fatura ORDER BY toplam DESC limit 1 "; 
if($query = mysql_query($sql)) 
{ 
 while ($row = mysql_fetch_assoc($query)) 
{ 
----- verileri cek------
}     
}  
?>