<?php
require("calldata.php");
$sql = "SELECT * FROM data384";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2] =$row[1];
$matrix[$n][3] =$row[2];
$matrix[$n][6] =$row[5];
$matrix[$n][7] =$row[6];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$age =$matrix[$n][1];
$c1[$age] =$matrix[$n][2];
$c2[$age] =$matrix[$n][3];
$c3[$age] =$matrix[$n][6];
$c4[$age] =$matrix[$n][7];
}
$sql = "SELECT * FROM data79";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2] =$row[1];
$matrix[$n][3] =$row[2];
$matrix[$n][6] =$row[5];
$matrix[$n][7] =$row[6];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$age =$matrix[$n][1];
$b1[$age] =$matrix[$n][2];
$b2[$age] =$matrix[$n][3];
$b3[$age] =$matrix[$n][6];
$b4[$age] =$matrix[$n][7];
}
$z1= 0;
$z2= 0;
for ($byear=1910;$byear<1950;$byear++){
$age = 2008 - $byear;
$z1 = $c1[$age] + $c2[$age] + $c3[$age] + $c4[$age];
$z2 = $b1[$age] + $b2[$age] + $b3[$age] + $b4[$age];
$ftime[$byear] = $z2 /$z1;
}
$sql = "truncate eli79";
$exe= mysql_query($sql,$link);
for ($byear=1910;$byear<1950;$byear++){
$x=$ftime[$byear];
$sql = "insert into eli79 values($byear,$x)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
print("79 女子平均加入年数3 計算終了");
?>
最終更新:2010年08月26日 18:42