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...
--
respect, Andrey.