Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id BF74A6500B4 for ; Wed, 30 Jul 2008 18:02:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 29795-06 for ; Wed, 30 Jul 2008 18:02:37 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from relais.videotron.ca (relais.videotron.ca [24.201.245.36]) by postgresql.org (Postfix) with ESMTP id E4EF464FFE4 for ; Wed, 30 Jul 2008 18:02:40 -0300 (ADT) MIME-version: 1.0 Content-transfer-encoding: 7BIT Content-type: text/plain; charset=UTF-8; format=flowed Received: from [192.168.0.51] ([96.21.103.185]) by VL-MH-MR002.ip.videotron.ca (Sun Java(tm) System Messaging Server 6.3-4.01 (built Aug 3 2007; 32bit)) with ESMTP id <0K4U00GZV7SEJ2A0@VL-MH-MR002.ip.videotron.ca> for pgsql-php@postgresql.org; Wed, 30 Jul 2008 17:02:39 -0400 (EDT) Message-id: <4890D6F6.40709@videotron.ca> Date: Wed, 30 Jul 2008 17:02:46 -0400 From: PJ User-Agent: Thunderbird 2.0.0.9 (Windows/20071031) To: Andy Shellam Cc: Lynna Landstreet , pgsql-php@postgresql.org Subject: Re: display query results References: <48909454.7040305@videotron.ca> <82E74D266CB9B44390D3CCE44A781ED90B64DC@POSTOFFICE.cranel.local> <4890A871.3020906@videotron.ca> <4890AA8C.9080907@spidersilk.net> <4890CA07.2040405@videotron.ca> <4890D124.7020506@mailnetwork.co.uk> In-reply-to: <4890D124.7020506@mailnetwork.co.uk> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200807/10 X-Sequence-Number: 3874 Annotated within text below: Andy Shellam wrote: > PJ wrote: >> Lynna Landstreet wrote: >> Well, it does explain things a little. Unfortunately, I have tried >> about everything imaginable before posting except the right thing. >> I can not visualize what it is that my query is returning. Here is >> what the code is: >> >> Whatever I enter as values for pg_fetch_result, the screen output is : >> >> resource(3) or type (pgsql result) >> *Warning*: pg_fetch_result() [function.pg-fetch-result >> ]: Unable to jump to row 1 >> on PostgreSQL result index 3 in >> */usr/local/www/apache22/data/k2/test1_db.php* on line *29* > > This suggests that there is no row 1 in your result-set. I believe it > is zero-based, so try fetching row 0 if your query only returns 1 row. Been there, done that. No change. > > >> I don't understand what $resuts is returning - if it is an entire >> row, the one that the field is in that I am looking for, then why do >> I not get a printout of the text that is in that field? The row in >> the table is the second row and the field I am trying to retrieve is >> the 4th field. > $results as explained previously is just a pointer to a recordset. > This analogy isn't brilliant, but think of your database table as a > book. Each row on a page within that book is a record, and the words > in that row are the data in the table's columns. > > When you run a query, think of yourself looking at the book's index > for a given word. The index will tell you the pages that word is on. > That's your $results - simply a pointer to your data. > > You then need to turn to that page in the book (pg_fetch_* functions) > to start examining the lines for the word you want. Once you've got > your line, you can find the word (column/data, from your array) you're > looking for. > > Now turn that into PHP and SQL. You run your query (looking in the > book's index) and the PostgreSQL driver will save the results into a > block of memory in your server's RAM, returning a resource > identifier. This is literally just saying "resource #3 is located at > this location in the computer's memory." When you look up a record > from that result-set, PHP then knows where to look for the data. > > I never really use the "or die" syntax, I tend to explicitly check the > return values of the functions. Try this: > > $db = pg_connect("host=localhost port=5432 dbname=med user=med > password=0tscc71"); > > // Note: according to > http://uk2.php.net/manual/en/language.types.boolean.php a resource > always evaluates to true, > // therefore !$db may not evaluate to false when connection fails. > if ($db === false) > { > die("Could not open connection to database server"); > } > > // generate and execute a query > $query = "SELECT description FROM glossary_item WHERE > name='Alcohol'"; > $results = pg_query($db, $query); > var_dump ($results); > > if ($results === false) > { > die("SQL query failed: " . pg_last_error($db)); > } > else if (pg_num_rows($results) == 0) > { > // Only do this if you were expecting at least 1 row back > die("SQL query returned no rows"); > } > > $results_formatted = pg_fetch_all($results); > echo "
"; // need this to show output better in a HTML page
>       var_dump($results_formatted);
>       echo "
"; // need this to show output better in a HTML page > > /* > $results_formatted will then be set out like follows: > > $results_formatted[row_index][column_name] = column_value > */ > pg_close($db); > ?> Tried your coding - returns: resource(3) of type (pgsql result) SQL query returned no rows The row is there... isn't that what were asking for? To go by the book, I even changed the description to * as noted before below. Something is rotten in Denmark. This is getting ridiculous - I have followed the instructions as specified in the Postgresql documentation and examples - and it just doesn't work. The db is like this.. int4 ||int4 || varchar(32)|| text _item_id || glossary_id || name || description _ 2 || 1 || Alcohol || One of thetwo major.... blah...blah.. blah >> Am I querying correctly? The table is "glossary_item", the row I want >> is the one that is unique in containing the word "Alcohol" in the >> column "name" >> >> I changed: $query = "SELECT * FROM glossary_item WHERE name= >> 'Alcohol'"; >> same result >> >> Picture me tearing out my hair... >> > > Regards, > > Andy >