En çok izlenen bugün, bu hafta (yardım)

$kontrol = mysql_query("SELECT * FROM hit WHERE video_id ='$video_id' and tarih = DATE(NOW())");
$say = mysql_num_rows($kontrol);


$kontrolhafta = mysql_query("SELECT * FROM hithafta WHERE video_id ='$video_id' and tarih >= DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)");
$sayhafta = mysql_num_rows($kontrolhafta);



$kontrolay = mysql_query("SELECT * FROM hitay WHERE video_id ='$video_id' and tarih >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)");
$sayay = mysql_num_rows($kontrolay);


if($say > 0) {
    mysql_query("UPDATE hit SET gun = gun + 1 WHERE video_id ='$video_id' and tarih = DATE(NOW())");
}
else
{
mysql_query("delete FROM hit WHERE video_id ='$video_id'");
mysql_query("INSERT INTO hit (video_id,tarih,gun,ay) VALUES ('$video_id',DATE(NOW()),1,1) ");
}


if($sayhafta > 0) {
    mysql_query("UPDATE hithafta SET gun = gun + 1 WHERE video_id ='$video_id' and tarih >= DATE_SUB(CURRENT_DATE, INTERVAL 7 DAY)");
}
else
{
mysql_query("delete FROM hithafta WHERE video_id ='$video_id'");
mysql_query("INSERT INTO hithafta (video_id,tarih,gun,ay) VALUES ('$video_id',DATE(NOW()),1,1) ");
}


if($sayay > 0) {
    mysql_query("UPDATE hitay SET gun = gun + 1 WHERE video_id ='$video_id' and tarih >= DATE_SUB(CURRENT_DATE, INTERVAL 30 DAY)");
}
else
{
mysql_query("delete FROM hitay WHERE video_id ='$video_id'");
mysql_query("INSERT INTO hitay (video_id,tarih,gun,ay) VALUES ('$video_id',DATE(NOW()),1,1) ");
}

select * from madvideo INNER JOIN hit ON madvideo.id = hit.video_id where hit.tarih = DATE(NOW()) order by hit.gun desc