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
