Re: false No rows returned error

On 23 Mar 2002 at 11:04, Jim Martinez wrote:

> <?
> $conn=pg_connect("user=scott");
>
> // make sure I'mconnecting to the correc db
> echo "<b>database name:". pg_dbname($conn)."</b></hr>\n";
>
> if (!$conn){
> exit(" connection failed: " . __FILE__ . __LINE__ . "error: " .
> pg_errormessage($conn) );
> }
>
> $sql = "select pin, last_section_completed, comment from demographics";
>
> $res = pg_exec($conn, $sql) || exit ("query failed: ".__FILE__ . __LINE__
> ."<br> sql is $sql" );

Change the above to this, just to be sure:

res = pg_exec($conn, $sql);
if (!$result) {
echo "query failed: ".__FILE__ . __LINE__ ."<br> sql is $sql" );
exit;
}

> if (!$res){ exit ("post query check failed");}

BTW: the above if isn't necessary given the above.

>
> //
> // script dies here (line 36), falling to the exit clause.
> // A warning is printed also :
> // Warning: Supplied argument is not a valid
> // PostgreSQL result resource
> // in /home/www/test/php_debug.php on line 36

Listen to this error.

> $rows = pg_numrows($res) || exit ("No rows returned ".__FILE__ ." line:".
> __LINE__ . "<br> sql is $sql" ); // line 36

--
Dan Langille
The FreeBSD Diary - http://freebsddiary.org/ - practical examples