PGSql error.

sri2002

I am getting this error when I try to connect to my pgsql db.
Warning: PostgreSQL query failed: ERROR: Relation 'tblpartnerdate' does not exist in /usr/home/consult/public_html/search.php on line 170

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/home/consult/public_html/search.php on line 171

My code is:
<?php
/ us institutions /
/ make db connection and execute query /
$query4="SELECT DISTINCT HigherEduInstitution
FROM sausmailingaddress, tblPartnerDate
WHERE HigherEduInstitution <> ''
AND IDUS = MailingListID
ORDER BY HigherEduInstitution ASC";

    $conn = pg_pconnect("dbname=ussa host=10.10.20.30 port=5432 user=ussa_readonly") or die("Could not connect!");
    $result_set = pg_exec( $conn, $query4 );
    $num_rows = pg_numrows($result_set);
    ?>

Where am I doing a mistake. Any ideas?
Thanks
Sri😕

BDKR

Warning: PostgreSQL query failed: ERROR: Relation 'tblpartnerdate' does not exist in /usr/home/consult/public_html/search.php on line 170

Warning: Supplied argument is not a valid PostgreSQL result resource in /usr/home/consult/public_html/search.php on line 171

Well first of all, the error message tells you what's wrong. You must learn how to read these. You will save yourself tons of time. 🙂

Anyways, there are two errors there. The second one is a result of the first. Now in the first, it says that the table name 'tblpartnerdate' does not exist. So that's it. Check you query to see if there are any typo's.

$query4="SELECT DISTINCT HigherEduInstitution
FROM sausmailingaddress, tblPartnerDate
WHERE HigherEduInstitution <> ''
AND IDUS = MailingListID
ORDER BY HigherEduInstitution ASC";

Perhaps tblParnterDate should be PartnerDate😕

Try that and let me know.

Hope that helps,
BDKR