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(at)cpsgroup(dot)com]
> Sent: Thursday, June 25, 1998 11:46 AM
> To: davez(at)istand(dot)com; pgsql-general(at)postgreSQL(dot)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