MySQL Database Php

  1. Home
  2. Php
  3. MySQL Database
  4. This is a function to display a table for Postgres results
Function ShowResults($result) {
if ($result) {
$rows = pg_NumRows($result);
$cols = pg_NumFields($result);
echo( "\n");
/* Create the headers */
echo( "\n");
for($i = 0; $i < $cols; $i++) {
printf( "\n", pg_FieldName($result, $i));
}
echo( "");
for($j = 0; $j < $rows; $j++) {
echo( "\n");
for($i = 0; $i < $cols; $i++) {
printf( "\n", pg_result($result, $j, $i));
}
echo( "");
}
echo( "
%s
%s
");
} else {
echo(pg_errormessage);
}
}
?>