RE: [PHP-DB] re: small question php/postgreSQL (basic question, not small)

The code does need to know what the fields are...I think a more likely issue is the query for some reason, also change the $query to result in the query statement try $result=pg_query($query) or die(pg_error()); //to see if there are any errors with the query while($row=pg_fetch_array($result,NULL,PGSQL_ASSOC)) { echo "Title: ".$row['isbn_no']."<br />"; echo "blah ".$row['code_livre']."<br />"; }else{ echo "No rows found"; } bastien

From: JeRRy <jusa_98@yahoo.com> To: php-db@lists.php.net Subject: [PHP-DB] re: small question php/postgreSQL (basic question, not small) Date: Tue, 7 Nov 2006 23:18:58 +1100 (EST)

      Date:  Tue, 7 Nov 2006 10:38:18 +0100 (CET)    From:  "Desmond Coughlan" <coughlandesmond@yahoo.fr>    To:  "php" <php-db@lists.php.net>    Subject:  small question php/postgreSQL

Hi, I've been trying to get a small DB up and working with PhP. It's a library, and so far, I can't get past the stage of displaying a page. I try the 'hello world' example, and it displays. I then populate a DB and can access it via psql .. cdi=> SELECT * FROM stock ; -[ RECORD 1 ]-+-------------------------------

stock_ids     | 1
isbn_no       | 10101010
code_livre    | 23455
titre         | toto goes to Hollywood
editeur       | editions toto
collection    | collection toto
auteur_nom    | smith

auteur_prenom | john

matiere       | ang
media_type    | li

-[ RECORD 2 ]-+-------------------------------

stock_ids     | 2
isbn_no       | 10536278
code_livre    | 24874
titre         | toto comes back from Hollywood
editeur       | editions baba
collection    | collection toto
auteur_nom    | martin

auteur_prenom | peter

matiere       | fre
media_type    | dvd

OK, I then write the following script .... <?php pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't Connect: ".pg _last_error()); $query="SELECT * FROM stock"; $query=pg_query($query); // start the output while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) { echo "Title: ".$row['isbn_no']."<br />"; echo "blah ".$row['code_livre']."<br />"; } ?> (sorry not to put that in italics or whatever...) ... and put it in the document root of my webserver, under php_experimental. I get a blank page. The apache weblogs look like ... 192.168.0.254 - - [07/Nov/2006:10:37:30 +0100] "GET /php_experimental/base.php HTTP/1.1" 200 - "-" "Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.0)" There's something obvious that I'm missing. Any ideas ..? Thanks. D. ------ re:

    <?php

pg_connect ("dbname=cdi user=cdi password=toto") or die ("Couldn't Connect: ".pg _last_error()); $query="SELECT * FROM stock"; $query=pg_query($query); // start the output while($row=pg_fetch_array($query,NULL,PGSQL_ASSOC)) { echo "Title: ".$row['isbn_no']."<br />"; echo "blah ".$row['code_livre']."<br />"; } ?> Simple, isbn_no and code_livre need to be "defined" in your code. Otherwise PHP don't know what your looking for. There is PLENTY of docs online to show you how to display items in a DB. Hello World is basic, too basic to use as an example and is a poor one to use. If your nerw you have to go a bit more into it than Hello World code. (which in my opinion gets you know-where) been there done that. Google how to display items in a DB in PHP and shoot you get some handy things. I just feel this question is not required here when google has all the answers like this. Jerry

_________________________________________________________________ Ready for the world's first international mobile film festival celebrating the creative potential of today's youth? Check out Mobile Jam Fest for your a chance to WIN $10,000! www.mobilejamfest.com