re: what is wrong with my code.. please help
| From: | Rob Cartier | Date: | Sun, 26 Dec 2004 17:56:52 +0000 |
| Subject: | re: what is wrong with my code.. please help | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-37859@lists.php.net to get a copy of this message | ||
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
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