".$id." order by id asc";
$res2 = @mysql_query($sql2);
for($i=0;$row2 = mysql_fetch_array($res2);$i++){
//echo $row2['description']."
";
//echo $row2['event_at']."
";
//echo $row2['address']."
";
$location=explode(",", $row2['location']);
if($location[0]!=null){
if($row2['img_url']!=null){
echo "insert into display_master (kanko_id,kanko_name,kanko_ido,kanko_keido,janru_id,gazoufile,regist_date,update_date) values(".$insert_id.",'".$row2['name']."','".$location[0]."','".$location[1]."',3,'".$row2['img_url']."',now(),now())";
}else{
echo "insert into display_master (kanko_id,kanko_name,kanko_ido,kanko_keido,janru_id,gazoufile,regist_date,update_date) values(".$insert_id.",'".$row2['name']."','".$location[0]."','".$location[1]."',3,'toshinaga.jpg',now(),now())";
}
}
echo "
";
print("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",0, '".$row2['description']."')");
echo "
";
print("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",1, ' ')");
echo "
";
print("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",2, '".$row2['event_at']."')");
echo "
";
print("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",3, '".$row2['address']."')");
echo "
";
for($cnt=4;$cnt<8;$cnt++){
print("insert into display_kankodata (kanko_id,gyou_id,kanko_data) values(".$insert_id.",".$cnt.", ' ')");
echo "
";
}
echo "
";
$insert_id++;
$id=$row2['id'];
}
echo $id;
//次回の読み込み開始場所の記録
/*$next_id=fopen("next_id.txt", "a");
if(flock($next_id,LOCK_EX)){
ftruncate($next_id,0);
fwrite($next_id,$id);
}
fclose($next_id);*/
mysql_free_result($res2);
$close = @mysql_close($con);
if(!$close){
unset($con,$sql,$res,$max,$db_select);
die();
}
unset($con,$sql,$res,$db_select,$kanko_id,$row,$res2,$next_id,$id,$cnt,$insert_id);
?>