Re: display query results

You need to fetch the results. See the pg_fetch_* family of functions for the one of your liking.

$myarray = pg_fetch_all($results);
print_r($myarray);

Greg

________________________________

From: pgsql-php-owner(at)postgresql(dot)org on behalf of PJ
Sent: Wed 7/30/2008 10:18 AM
To: pgsql-php(at)postgresql(dot)org
Subject: [PHP] display query results

I am trying to learn postgresql with psql - using FreeBS D7.0,
postgresql 8.3.3 php 5.2.6, apache 2.2.9

How can I echo or print on screen the results; all I get from this code
is this:
Resource id #3
item_idglossary_idnamedescription
which is the field names run together

I am expecting to see several long text sentences.

Here is the snippet and the connection does work and the database is
there and functioning.

$db = pg_connect("host=localhost port=5432 dbname=med user=med
password=0tscc71");

if (!$db)
{
die("Could not open connection to database server");
}

// generate and execute a query
$query = "SELECT description FROM glossary_item WHERE
name='Alcohol'";
$result = pg_query($db, $query) or die("Error in query: $query.
" . pg_last_error($db));

// Print result on screen
echo "$result";

pg_close($db);

What am I doing wrong?

--
Sent via pgsql-php mailing list (pgsql-php(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php

CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain confidential and privileged information for the use of the designated recipients named above. If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, distribution or copying of it or its contents is prohibited. If you have received this communication in error; please notify Cranel Incorporated immediately by telephone at 614-431-8000 or 800-288-3475 and destroy all copies of this communication and any attachments.