Skip site navigation (1) Skip section navigation (2)

RE: [GENERAL] pg_result

From: "Jackson, DeJuan" <djackson(at)cpsgroup(dot)com>
To: davez(at)istand(dot)com, pgsql-general(at)postgreSQL(dot)org
Subject: RE: [GENERAL] pg_result
Date: 1998-06-25 15:46:27
Message-ID: F10BB1FAF801D111829B0060971D839F2F907B@cpsmail (view raw or flat)
Thread:
Lists: pgsql-general
> 	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

pgsql-general by date

Next:From: liewDate: 1998-06-25 16:02:00
Subject: Please Help
Previous:From: davezDate: 1998-06-25 15:28:51
Subject: pg_result

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group