ぱんだ３０ - プログラム倉庫

<?php
require("calldata.php");
$sql = "SELECT * FROM pdata07";
$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 < 96; $n++) {
$year =$matrix[$n][1];
$p[$year] = $matrix[$n][2];
}
$sql = "SELECT * FROM pdata08";
$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 < 96; $n++) {
$year =$matrix[$n][1];
$g[$year] = $matrix[$n][2];
}

$sql = "SELECT * FROM pgdata29";
$result = mysql_query($sql, $link);

while( $row = mysql_fetch_row( $result ) ){
$year = $row[0];
$kiso[$year] =$row[1];
}
for ($year=5;$year<100;$year++){
$rev=80*$kiso[$year];
$exp[$year]=$rev;
}

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

for ($year=5;$year<100;$year++){
$x=$exp[$year];
$sql = "insert into pgdata30 values($year,$x)";
$exe= mysql_query($sql,$link);
}
$close_flag = mysql_close($link);
?>