Hello,
I am trying to query and show it by fetching all the row but actually only one row shows up
not all the rows by defined condition.
The code is
<?php
$db=pg_connect("host=localhost dbname=xxxx user=xxxx password=xxxx ");
..........................................................
$result=pg_query($db,"select id,credit from cc_cdr where id<=20500 AND id>=10501 AND credit<5 ORDER BY id ASC");
$row=pg_fetch_array($result);
echo $row["id"];
echo $row["credit"];
?>
i can see only one , the first row
if i change pg_fetch_all($result)
nothing show up
what will i do in this case?