date_default_timezone_set("Turkey");

$tarihsaat = date("Y-m-d H:i:s");

$gecenhafta = date("Y-m-d H:i:s",time()-7*86400);

$sorgu = "select * from video where tarih BETWEEN '$gecenhafta' AND '$tarihsaat' ORDER BY hit DESC LIMIT 0,5";