Last 1000
");
$conn = pg_connect("dbname=quantifiedself port=5432");
$result = pg_query($conn, "select * from data;");
$num = pg_numrows($result);
$col_num = pg_numfields($result);
// Only show last...
if (isset($_GET["limit"]) && $_GET["limit"] < 1000000)
{
$limit = $_GET["limit"];
}
else
{
$limit = $num;
}
echo "";
for ($i=($num - $limit); $i<$num; $i++) {
$line = pg_fetch_array($result, $i, PGSQL_ASSOC);
print "\t\n";
for ($j=0; $j<$col_num; $j++){
list($col_name, $col_value) =each($line);
print "\t\t| $col_value | \n";
}
}
echo "
";
?>