Code Comments
Programming Forum and web based access to our favorite programming groups.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.
Script:
$conn = pg_connect("user = $user dbname = $dbname host
= $host password = $pass");
if (!$conn)
{
echo('could not establish connection with
database <br>');
exit;
}
$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
kumar
________________________________________
__________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
Post Follow-up to this messagewell 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 Rob ======================================== ============== 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. Script: $conn = pg_connect("user = $user dbname = $dbname host = $host password = $pass"); if (!$conn) { echo('could not establish connection with database <br>'); exit; } $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 kumar
Post Follow-up to this messagePowered by vBulletin
Copyright 2000-2006 Jelsoft Enterprises Limited.