From: | Jason <neumeier(at)bright(dot)net> |
---|---|
To: | "'Jackson, DeJuan'" <djackson(at)cpsgroup(dot)com>, davez(at)istand(dot)com, pgsql-general(at)postgreSQL(dot)org |
Subject: | RE: [GENERAL] pg_result |
Date: | 1998-06-25 17:13:38 |
Message-ID: | 908DAF4A5E00D211B54C00400543592D6222@ariel.telserco.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
$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
From | Date | Subject | |
---|---|---|---|
Next Message | Jackson, DeJuan | 1998-06-25 17:26:20 | RE: [GENERAL] pg_result |
Previous Message | David Zampese | 1998-06-25 16:20:36 | RE: [GENERAL] pg_result |