ｐろ１６ - プログラム倉庫

<?php
require("calldata.php");
$sql = "SELECT * FROM pgdata08";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$n=$n+1;
}
for ($n=1; $n < 51; $n++) {
$byear =$matrix[$n][1];
$mnew[$byear]=$matrix[$n][2];
}
$sql = "SELECT * FROM pgdata12";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$n=$n+1;
}
for ($n=1; $n < 51; $n++) {
$byear =$matrix[$n][1];
$mnew[$byear]=$matrix[$n][2];
}
$sql = "SELECT * FROM pgdata10";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$n=$n+1;
}
for ($n=1; $n < 51; $n++) {
$byear =$matrix[$n][1];
$fnew[$byear]=$matrix[$n][2];
}
$sql = "SELECT * FROM pgdata14";
$result = mysql_query($sql, $link);
$n=1;
while( $row = mysql_fetch_row( $result ) ){
$matrix[$n][1] = $row[0];
$matrix[$n][2]  =$row[1];
$n=$n+1;
}
for ($n=1; $n < 51; $n++) {
$byear =$matrix[$n][1];
$fnew[$byear]=$matrix[$n][2];
}
$sql = "truncate pgdata16";
$exe= mysql_query($sql,$link);

for ($byear=1941;$byear<2036;$byear++){
$x=$mnew[$byear];
$y=$fnew[$byear];
$sql = "insert into pgdata16 values($byear,$x,$y)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);




?>