<?php
require("calldata.php");
$sql = "SELECT * FROM pgdata01";
$result = mysql_query($sql, $link);
while( $row = mysql_fetch_row( $result ) ){
$year = $row[0];
$age = $row[1];
$m[$year][$age] =$row[2];
$f[$year][$age] =$row[3];
}
for ($year=5;$year<100;$year++){
$z1=0;
for ($age=65;$age<99;$age++){
$z1=$z1+$m[$year][$age]+$f[$year][$age];
}
$kiso[$year]=$z1;
}
$sql = "truncate pgdata29";
$exe= mysql_query($sql,$link);
for ($year=5;$year<100;$year++){
$x=$kiso[$year];
$sql = "insert into pgdata29 values($year,$x)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
?>
最終更新:2009年06月15日 08:17