RE: [GENERAL] pg_result

Dave,


>
> $result = pg_Exec($conn, "$query");
> if (!$result);
>         echo "An error occured inserting information into our
> database.\n";
>         exit;
> else;
>         pg_close ($conn);
> endif;
> $rows = pg_result($result,0,"row1");
>



(Assuming you're using php3)

I think something like this is what you're looking for:

   $conn = pg_Connect("localhost", "5432", "", "", "efakt");
   if (!$conn) {
      echo "Cannot connect to PostgreSQL database.\n";
      exit;
   }

   $result = pg_Exec($conn, "set datestyle='ISO';
             select * from invoices
              where seqid = $invid");
   if (!$result) {
      echo "Faktuur niet gevonden! ($resinv $invid)\n";
      exit;
   }


   $num = pg_NumRows($result);
   $i = 0;

   while ($i < $num) {
      echo pg_Result($result, $i, "invoiceno");
      $i++;
   }

   pg_FreeResult($result);
   pg_Close($conn);



Rob den Boer