[PHP] psql with PHP question - Mailing list pgsql-novice

From Jason
Subject [PHP] psql with PHP question
Date
Msg-id 3AF149C1.AEC30AA9@mediaone.net
Whole thread Raw
In response to Problems compiling 7.1 with TCL support on Solaris 7  (Andy Howarth <andy@is3-design.com>)
List pgsql-novice
Hi, I want to try  and optimize my calls to postgreSQL from PHP.  If
I only need one field from a select statement, what should I use?  I am
currently using:
$q = pg_Exec("SELECT id FROM article WHERE id=(SELECT MAX(id)
FROM article)");
$maxid = pg_fetch_array($q, 0);
echo "The highest id is ". $maxid[0];
What can I use besides an array to get a single value? In general, using
a single variable always saves more memory than using an array?  Thank
you.
Jason


pgsql-novice by date:

Previous
From: Luis Amigo
Date:
Subject: bug?? on oid2name
Next
From: Adrian Stovall
Date:
Subject: Perl and pgsql...