pg_fetch_array() does not work with PostgreSQL?
| From: | jeam at themail dot com | 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