$sorgu = "select * from video where tarih BETWEEN UNIX_TIMESTAMP('".date('Y-m-d',time()-(86400*7)." 00:00:00') AND UNIX_TIMESTAMP('".date('Y-m-d')." 23:59:59') ORDER BY hit DESC LIMIT 0,10 ";

böyle dene?