well here a few things. 1. Have you setup your php.ini file
to log errors to your apache error_log file or a unique
php_error.log file

2. Lines $sql = "select * from experiment;"
$sth = pg_exec($connect,$sql)

are both missing sem-colons

also once you establish that errors are going to your lof files the rest should be a peice of cake

Good luck

Dear group, I am trying to query my db and print the results.
when i execute my script, i am not getting any result
except a blank page. can any one please help me what
is going wrong with my script.

$conn = pg_connect("user = $user dbname = $dbname host
= $host password = $pass");
if (!$conn)
      echo('could not establish connection with
database <br>');
$sql = "select * from experiment;"
$sth = pg_exec($connect,$sql)
if (! $sth){
die("Can't execute query".pg_errormessage());

for($i = 0,$j = pg_numrows($sth);$i < $j;$i++){
$ar = pg_fetch_row($sth,$i);
foreach($ar as $col){
print "$col ";
print "\n";


thank you in advance


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to