ｐｈｐ７３ - プログラム倉庫

<?php
require("calldata.php");

$sql = "SELECT * FROM eli20";
$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];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$age =$matrix[$n][1];
$car = $matrix[$n][2];
$startmis[$age][$car]= $matrix[$n][3];
}

$sql = "SELECT * FROM eli22";
$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];
$n=$n+1;
}
$maxn=$n;
for ($n=1; $n < $maxn; $n++) {
$age =$matrix[$n][1];
$car = $matrix[$n][2];
$startmos[$age][$car]= $matrix[$n][3];
}


for ($age=60;$age<70;$age++){
$p1=0;
for ($car=25;$car<50;$car++){
$p1=$p1+$startmis[$age][$car]+$startmos[$age][$car];
}
$fnew[$age]=$p1;
}

$sql = "truncate eli73";
$exe= mysql_query($sql,$link);

for ($age=60;$age<70;$age++){
$x=$fnew[$age];
$sql = "insert into eli73 values($age,$x)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
print("73 女子新規裁定者３　計算終了");
?>