I don't see any generic errors. What I would do is insert debugging
statments after DB::connect, after the query, and inside the while loop
and see which one fails to show up. (Like "Connected", "Query
Returned", and "Looping While...") This should help you find out what
command is failing to complete.
Hope this helps..
Dave
dr_sad(surguttel) wrote:
use:
Linux SuSE 8.0 Pro
PostgreSQL 7.2
PHP 4.2.2
Apache 2.0.39
All posible deb messages in php.ini are enabled, but follow code:
-------------------------------------------------------------------------------
<html>
<head>
<title>PostgreSQL PHP Test</title>
</head>
<body>
<table>
<?
printf("BEGIN<br>");
require_once('DB.php');
$userid='postgres';
$password='gecnzr';
$dbhost='dbserv';
$database='ll';
$db = DB::connect("pgsql://$userid:$password@$dbhost/$database");
if ( DB::iserror( $db ))
{
die("DB.connect " . $db->getMessage());
}
$sql = "select * from agreements";
$q = $db->query( $sql );
if ( DB::iserror( $q ))
{
die("Query " . $q->getMessage());
}
while ( $row = $q->fetchRow() )
{
?>
<tr><td><?=$row[0] ?> </td>
<td><?=$row[1] ?> </td>
<td><?=$row[2] ?> </td>
<td><?=$row[3] ?> </td>
</tr>
<?
}
printf("END.<br>");
?>
</table>
</body>
</html>
-------------------------------------------------------------------------------
return follow html:
------------------------------
<html>
<head>
<title>PostgreSQL PHP Test</title>
</head>
<body>
<table>
BEGIN<br>
------------------------------
can anybody help me? I don't see any error messages both apache and
php logs... :( If I change sitax of command, of course i see error
messages... Heh...
