Thread

RE: [GENERAL] pg_result

Jason <neumeier@bright.net> — 1998-06-25T17:13:38Z

$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