Need Help Postgresql PHP

[russmc]

Please advise
I keep getting the errors below with the following code:

$getCompany = pg_exec($db,"$queryString");

                            $companyName = pg_result($getCompany,0,'companyname');
                            $companyAddress =  pg_result($getCompany,0,'companyaddress');
                            $city =  pg_result($getCompany,0,'city');
                            $state =  pg_result($getCompany,0,'state');
                            $zip =  pg_result($getCompany,0,'zip');
                            $voicePhone =  pg_result($getCompany,0,'voicephone');
                            $faxPhone =  pg_result($getCompany,0,'faxphone');
                            $email =  pg_result($getCompany,0,'email');
                            $companyWebsiteURL =  pg_result($getCompany,0,'companywebsiteurl');
                            $linkEmail = pg_result($getCompany,0,'linkemail');
                            $linkURL =  pg_result($getCompany,0,'linkurl');
                            $description =  pg_result($getCompany,0,'description');

Warning: 3 is not a valid PostgreSQL link resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 33

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 35

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 36

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 37

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 38

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 39

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 40

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 41

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 42

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 43

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 44

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 45

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/local/share/doc/apache/include/databaselib.php.inc on line 46

I have tried a number of things and have run out of ideas!
any help would be great!!

[gid]

Sounds like your not connected properly to your postgresql database. Try using functions like pg_result_error or pg_last_error to see what's the cause of your initial sql error.

Btw, you might want to do something like:

$getCompany = pg_exec($db,"$queryString");
echo pg_result_error($getCompany);
$row = pg_fetch_object($getCompany, 0);

now you have a nice neat object, instead of tons of small variables.