pg_fetch_array() does not work with PostgreSQL?

From: Date: Sat, 22 Jul 2000 06:11:55 +0000
Subject: pg_fetch_array() does not work with PostgreSQL?
Groups: php.general 
Request: Send a blank email to php-general+get-8147@lists.php.net to get a copy of this message
Hi there. Here's my problem: $sql="SELECT A.INVOICE, B.NAME " ."FROM INVOICES A, CUSTOMERS B " ."WHERE B.CUSTOMER=A.CUSTOMER;"; After a succesfull $result set, I try this: $row=pg_fetch_array($result,0); echo $row["NAME"]; // Nothing is printed. echo $row["B.NAME"]; // Nothing is printed. echo $row[0]; // A customer name is printed! echo pg_Result($result,0,"NAME"); // A name is also printed. What gives? The last two examples work, the first two does not. Any help is much appreciated. Thanks in advance, Jorge. Using PostgreSQL 6.5.3, PHP 3.0.12 __________________________________________________________________ Make A Buck Or Two @ TheMail.com - Free Internet Email Sign-up today at http://www.themail.com/ref.htm?ref=908313

« previous php.general (#8147) next »