A |
B |
rA |
|
|
$conn=pg_connect("host=localhost dbname=spi user=robby");
if($a && $b && $ra) {
pg_exec("insert into spi(a,b,ra,\"D\") values('$a','$b','$ra','now');");
mail("robby@dogbomb.com","new spi added","a=$a b=$b and ra=$ra","From: poop@dogbomb.com\r\n");
}
$result=pg_exec("select * from spi order by \"D\";");
$num=pg_numrows($result);
for($i=0;$i<$num;$i++)
$spi[$i]=pg_fetch_array($result,$i);
for($i=0;$i<$num;$i++){
if(!( $spi[$i][a] == $spi[$i-1][a] &&
$spi[$i][b] == $spi[$i-1][b] &&
$spi[$i][ra] == $spi[$i-1][ra] ))
echo"
".$spi[$i][a]." |
".$spi[$i][b]." |
".$spi[$i][ra]." |
See |
";
}
pg_close($conn);
?>