I tried it but it still didn't work.
Thanks,
Dave
Date: Thu, 25 Jun 1998 10:46:27 -0500
From: "Jackson, DeJuan" <djackson@cpsgroup.com>
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
