Thread: RE: [GENERAL] pg_result

RE: [GENERAL] pg_result

From
"Jackson, DeJuan"
Date:
>     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