PHP57 - プログラム倉庫

<?php
require("calldata.php");
$sql = "SELECT * FROM plan";
$result = mysql_query($sql, $link);
while( $row = mysql_fetch_row( $result ) ){
$plan = $row[0];  
}  
$pl=1;
if ($plan==1)$pl=1;
if ($plan==2)$pl=2;
if ($plan==3)$pl=3;

$sql = "SELECT * FROM data5701";
$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][4]  =$row[3];
$matrix[$n][5] = $row[4];
$matrix[$n][6]  =$row[5];
$matrix[$n][7]  =$row[6];
$matrix[$n][8]  =$row[7];
$matrix[$n][9]  =$row[8];
$matrix[$n][10]  =$row[9];
$matrix[$n][11]  =$row[10];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$year =$matrix[$n][1];
$b1[$year][1] = $matrix[$n][2];
$b2[$year][1] = $matrix[$n][3];
$b3[$year][1] = $matrix[$n][4];
$b4[$year][1] = $matrix[$n][5];
$b5[$year][1] = $matrix[$n][6];
$b6[$year][1] = $matrix[$n][7];
$b7[$year][1] = $matrix[$n][8];
$b8[$year][1] = $matrix[$n][9];
$b9[$year][1] = $matrix[$n][10];
$b10[$year][1] = $matrix[$n][11];
}

$sql = "SELECT * FROM data5702";
$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][4]  =$row[3];
$matrix[$n][5] = $row[4];
$matrix[$n][6]  =$row[5];
$matrix[$n][7]  =$row[6];
$matrix[$n][8]  =$row[7];
$matrix[$n][9]  =$row[8];
$matrix[$n][10]  =$row[9];
$matrix[$n][11]  =$row[10];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$year =$matrix[$n][1];
$b1[$year][2] = $matrix[$n][2];
$b2[$year][2] = $matrix[$n][3];
$b3[$year][2] = $matrix[$n][4];
$b4[$year][2] = $matrix[$n][5];
$b5[$year][2] = $matrix[$n][6];
$b6[$year][2] = $matrix[$n][7];
$b7[$year][2] = $matrix[$n][8];
$b8[$year][2] = $matrix[$n][9];
$b9[$year][2] = $matrix[$n][10];
$b10[$year][2] = $matrix[$n][11];
}

$sql = "SELECT * FROM data5703";
$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][4]  =$row[3];
$matrix[$n][5] = $row[4];
$matrix[$n][6]  =$row[5];
$matrix[$n][7]  =$row[6];
$matrix[$n][8]  =$row[7];
$matrix[$n][9]  =$row[8];
$matrix[$n][10]  =$row[9];
$matrix[$n][11]  =$row[10];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$year =$matrix[$n][1];
$b1[$year][3] = $matrix[$n][2];
$b2[$year][3] = $matrix[$n][3];
$b3[$year][3] = $matrix[$n][4];
$b4[$year][3] = $matrix[$n][5];
$b5[$year][3] = $matrix[$n][6];
$b6[$year][3] = $matrix[$n][7];
$b7[$year][3] = $matrix[$n][8];
$b8[$year][3] = $matrix[$n][9];
$b9[$year][3] = $matrix[$n][10];
$b10[$year][3] = $matrix[$n][11];
}


$sql = "truncate eli57";
$exe= mysql_query($sql,$link);
for ($year=10;$year<100;$year++){  
$x1=$b1[$year][$pl];
$x2=$b2[$year][$pl];
$x3=$b3[$year][$pl];
$x4=$b4[$year][$pl];
$x5=$b5[$year][$pl];
$x6=$b6[$year][$pl];
$x7=$b7[$year][$pl];
$x8=$b8[$year][$pl];
$x9=$b9[$year][$pl];
$x10=$b10[$year][$pl];
$sql = "insert into eli57 values($year,$x1,$x2,$x3,$x4,$x5,$x6,$x7,$x8,$x9,$x10)";
$exe= mysql_query($sql,$link);  
}
$close_flag = mysql_close($link);
print("57 財政収支 計算終了");
?>