Re: display query results

On Wednesday 30 July 2008 12:18:28 PJ wrote:
> 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?

pg_query just gives you a pointer to the result set, to get the actual
information in the result, you need to use one of the other pg_ functions to
grab that. ie. http://us.php.net/manual/en/function.pg-fetch-result.php (and
about a dozen others)

--
Robert Treat
Build A Brighter LAMP :: Linux Apache {middleware} PostgreSQL