$from_time and acc_time<=$to_time group by filenum limit 10;";
//$sql="SELECT filenum,user_ip FROM access_total WHERE acc_time>$from_time and acc_time<=$to_time group by filenum,user_ip limit 30;";
$sql="delete from itizi;";
$con->query($sql);
$sql="INSERT INTO itizi (SELECT filenum,user_ip FROM access_total WHERE acc_time>$from_time and acc_time<=$to_time group by filenum,user_ip);";
$con->query($sql);
$sql="SELECT utamap_kasi2.filenum,utamap_kasi2.title,utamap_kasi2.artist,topid.ipcount from utamap_kasi2, (SELECT filenum, count(user_ip) as ipcount FROM itizi group by filenum order by ipcount desc limit 100) as topid where topid.filenum=utamap_kasi2.filenum;";
$rank_cd=0;
foreach ($con->query($sql) as $row) {
$filenum=$row['filenum'];
$cntacs=$row['ipcount'];
$title=$row['title'];
$artist=$row['artist'];
//print $filenum."-----".$cntacs." ";
$title = mb_convert_encoding($title, "utf-8", "EUC-JP");
$artist = mb_convert_encoding($artist, "utf-8", "EUC-JP");
//////////////////////////////////////
$rank_cd=$rank_cd+1;
$ur2="http://www.utamap.com/show_cds.php?surl={$filenum}";
//////////////////////////////////////
if($rank_cd<4){
$sw_contents3.=<<