Re: [PHP] postgresql database access failure

2011-05-02 Thread e-letter
The query was: $query = 'SELECT * FROM databasetablename'; So, database access seems to be the problem. Using the superuser account 'postgres', a user 'httpd' was created and all privileges were granted to the target database using the postgresql 'grant' command. However the user 'httpd' is not t

Re: [PHP] postgresql database access failure

2011-05-01 Thread David Robley
e-letter wrote: > The file was changed: > > ... $value=pg_fetch_result($query,1,1); > echo 'all files' . var_dump($value); > ... > > The resultant web page produces: > > bool(false) all files > > The php file was changed again: > > ... $value=pg_fetch_result($query); > ech

Re: [PHP] postgresql database access failure

2011-05-01 Thread e-letter
The file was changed: ... $value=pg_fetch_result($query,1,1); echo 'all files' . var_dump($value); ... The resultant web page produces: bool(false) all files The php file was changed again: ... $value=pg_fetch_result($query); echo 'all fi

Re: [PHP] postgresql database access failure

2011-05-01 Thread Ashley Sheridan
On Sun, 2011-05-01 at 09:24 +0100, e-letter wrote: > I looked at the error file located at '/var/log/httpd/error_log', > which identifies an error: > > ...Apache/2.2.6 (Mandriva Linux/PREFORK-8.2mdv2008.0) PHP/5.2.4 with > Suhosin-Patch mod_put/2.0.8 configured -- resuming normal > operations...

Re: [PHP] postgresql database access failure

2011-05-01 Thread e-letter
On 30/04/2011, Daniel Brown wrote: > Readers? Sounds like you spend too much time writing newsletters > (to the wrong address, since php-general-digest-h...@lists.php.net is > a self-help command list for digest-form subscriptions). ;-P > > On Sat, Apr 30, 2011 at 04:41, e-letter wrote: >>

Re: [PHP] postgresql database access failure

2011-04-30 Thread Daniel Brown
On Sat, Apr 30, 2011 at 12:23, Daniel Brown wrote: >> >>        >                echo '$_SERVER['HTTP_USER_AGENT']'; >>        ?> > >    First of all, no it doesn't.  Placed inside single quotes, it'll > not only try to return it verbatim (i.e. - the variable would be > printed to screen), but it'

Re: [PHP] postgresql database access failure

2011-04-30 Thread Daniel Brown
Readers? Sounds like you spend too much time writing newsletters (to the wrong address, since php-general-digest-h...@lists.php.net is a self-help command list for digest-form subscriptions). ;-P On Sat, Apr 30, 2011 at 04:41, e-letter wrote: >                        $db = pg_connect('dbnam