When I execute the following code segment with the $EmailAddress and $Password variables set to values that exist in the PostgreSQL 6.5.3 table, everything works fine.

When I execute it with values that are NOT in the table, pg_exec still returns a "true" value even though the SELECT statement never found any matching rows.  (This is contrary to what the documentation implies when it tests for !$result.)

The actual value of the $query variable, even when the query sent by the pg_exec function fails, is "Resource id #2".  Because it's not falst, there's no way to test whether the query succeeded.  So when the program goes on to execute the pg_fetch_array function, the $query variable points to nothing and the program dies with an error message.


-------------------------------

<?php
// -- This module checks a username and password to see who the user is.)
$db = pg_connect("", "", "", "", "tracker");
if ($db) {
    $SQLQuery = "SELECT userid FROM users WHERE username = '" . $EmailAddress . "' AND password = '" . $Password . "';";
    $query = pg_exec($db, $SQLQuery);
    if ($query) {
        $row = 0;
        if ($data = pg_fetch_array($query, $row)) {
            // Etc...