RE: [GENERAL] pg_result

$result points to the result structure.  I.e.

    $result_status = $result->resultStatus

Returns the status of the result. For comparing the status you
may use one of the following constants depending upon the
command executed:

  - PGRES_EMPTY_QUERY
  - PGRES_COMMAND_OK
  - PGRES_TUPLES_OK
  - PGRES_COPY_OUT
  - PGRES_COPY_IN
  - PGRES_BAD_RESPONSE
  - PGRES_NONFATAL_ERROR
  - PGRES_FATAL_ERROR


See Pg.pm for all of the result structure.

> -----Original Message-----
> From:    Jackson, DeJuan [SMTP:djackson@cpsgroup.com]
> Sent:    Thursday, June 25, 1998 11:46 AM
> To:    davez@istand.com; pgsql-general@postgreSQL.org
> Subject:    RE: [GENERAL] pg_result
>
> >     I have looked all over the site and I can not find good
> > description for
> > 'pg_result'  I am having this problem.  My database and everthing is
> > working fine but when I try to run a query from an html webpage it
> is
> > not
> > working and I believe it is my 'pg_result' command.  I have a table
> > with
> > 5-6 columns of information and I want total records to be selected.
> I
> > then
> > reference the call to a variable and call it further in my HTML, but
> > nothing prints up.  I have tried naming all the fields where 'row1'
> is
> > below but it also doesn't work.  I am not getting any errors and
> html
> > prints back except for any values for '$rows', not even the row1
> > values
> > will come back. My query command works fine in psql.
> >     Does anyone see my problem?
> >
> > $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");
> >
> >     Thanks in advance,
> >     Dave
> Close the connection after you are done retrieving the results.
>     -DEJ