From: | PJ <af(dot)gourmet(at)videotron(dot)ca> |
---|---|
To: | pgsql-php(at)postgresql(dot)org |
Subject: | display query results |
Date: | 2008-07-30 16:18:28 |
Message-ID: | 48909454.7040305@videotron.ca |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | Postg메이저 토토 사이트SQL : Postg메이저 토토 사이트SQL 메일 링리스트 : 2008-07-30 이후 PGSQL-PHP 16:18 |
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?
From | Date | Subject | |
---|---|---|---|
Next Message | Spiegelberg, Greg | 2008-07-30 16:29:15 | Re: display query results |
Previous Message | Andrew McMillan | 2008-06-26 11:54:13 | Re: newbie issues with PDO / stored procedures |