[PHP] Problem querying postgres

2004-08-13 Thread Joshua Capy
Hi, I am new to postgres using PHP. I have gotten PHP POSTGRES and PHPADMIN installed and have a database setup using PHPADMIN. The problem that I am having is that when I connect to postgres outside of PHPADMIN and try use pg_query() to do a select such as SELECT PersonID FROM person the

RE: [PHP] Problem querying postgres

2004-08-13 Thread Michael Sims
Joshua Capy wrote: of PHPADMIN and try use pg_query() to do a select such as SELECT PersonID FROM person the string that is sent is select personid from person. Now this is a problem because in the data base the field PersonID is not the same case as in the select that is sent and I get the

RE: [PHP] Problem querying postgres

2004-08-13 Thread Jay Blanchard
[snip] I am new to postgres using PHP. I have gotten PHP POSTGRES and PHPADMIN installed and have a database setup using PHPADMIN. The problem that I am having is that when I connect to postgres outside of PHPADMIN and try use pg_query() to do a select such as SELECT PersonID FROM person the

[PHP] Problem with postgres

2004-06-01 Thread alantodd
I have php with pg and mysql commands working on the web site all scripts work. When I call them from the cmdline I get a different story. Call to undefined function: pg_connect() but run the same script from the web and it works no problem.. Anyone have some insight why this is happening

Re: [PHP] Problem with postgres

2004-06-01 Thread Jason Wong
On Wednesday 02 June 2004 01:31, alantodd wrote: I have php with pg and mysql commands working on the web site all scripts work. When I call them from the cmdline I get a different story. Call to undefined function: pg_connect() but run the same script from the web and it works no problem..

[PHP] problem with postgres integration

2002-10-31 Thread suman
Hi all i'm having a strange problem while compiling php 4.2.3 i compiled php with these options Configure Command './configure' '--with-mysql=/usr/local/mysql/' '--with-apxs=/usr/local/apache/bin/apxs' '--with-openssl=/usr/local/ssl/' '--with-pear' '--with-gd' '--with-pqsql=/usr/local/pgsql/'