PostgreSQL query errors

grail

Warning: Unable to jump to row 1 on PostgreSQL result index 2

What would cause this error to occurr, and how would it be resolved. Included is the code that produces this error.

<?php
require_once("graphic.inc");
echo "Here is the Donor information for: $Array[donorname2] ";
if (!$Array[donorname2])
{
echo "You have not entered any search information. "
."Please go back and try again.";
exit;
}
$conn = pg_pconnect("host=localhost port=5432 dbname=accounting user=postgres");
if (!$conn)
{
echo "ERROR: Could not connect to database. Please try again later.";
exit;
}
$sql = "select from donor where donorname2 = '$Array[donorname2]' order by donorid desc";
$result = pg_exec($conn, $sql);
echo "Search results";
echo "<hr>";
if ($result)
/ ($qry = pg_fetch_array($result,0))*/
{
$qry = pg_fetch_array($result,1);
echo $qry["donorid"];
$qry = pg_fetch_array($result,2);
echo $qry["donorid"];
$qry = pg_fetch_array($result,3);
echo $qry["donorname"];
$qry = pg_fetch_array($result,4);
echo $qry["donorname2"];
}
else
{echo "There where no documents found to match your criteria.";}
pg_close($conn);
?>

amcgrath

Hae you tried putting an @ sign in front of the pg_fetch_array? It can't jump to a row that doens't exist. And, instead of the way you are doing it, try this:

$tick = 0;

while($row = @pg_fetch_array($result,$tick++)) {
echo $row["donorid"];
}

grail

Well, that gets rid of the errors, however I still dont get any data to return. Any ideas on that?

Here is the modified code:

<?php
require_once("graphic.inc");
echo "Here is the Donor information for: $Array[donorname2] ";
if (!$Array[donorname2])
{
echo "You have not entered any search information. "
."Please go back and try again.";
exit;
}
$conn = pg_pconnect("host=localhost port=5432 dbname=accounting user=postgres");
if (!$conn)
{
echo "ERROR: Could not connect to database. Please try again later.";
exit;
}
$sql = "select * from donor where donorname2 = '$Array[donorname2]' order by donorid desc";
$result = pg_exec($conn, $sql);
echo "Search results";
echo "<hr>";
$tick = 0;
if ($result)
while($row = @pg_fetch_array($result,$tick++))
{
echo $row["donorid"];

I should get a number back from the database that correspondes with the donorid# held in that database column.

amcgrath

if ($result) {
while($row = @pg_fetch_array($result,$tick++)) {
echo $row["donorid"];
}
}

Other than that., everything does look right. Let me know.

grail

ok I have finally gotten this working, I need it to perform the while loop and grab the next row of data in the database and contiune this untill there is are no more rows that meet the search criteria. I have a "while" loop set up for this but instead of produceing the next row of data in the database, it just repeats the initial row and never stops. How can I have it grab the next row that fits the search criteria and print that out too?

Here is the code Im working on:

if($result) {
echo "<table border=1 cellpadding=5>";

echo "<td>Donor ID</td>";
echo "<td>First,Last Name</td>";
echo "<td>Last,First Name</td>";
echo "<td>Home Phone</td>";
echo "<td>Work Phone</td>";
echo "<td>Cell Phone</td>";
echo "</tr>";
while($row = @pg_fetch_array($result,0))
{
printf("<td>$row[1]</td>");
printf("<td>$row[2]</td>");
printf("<td>$row[3]</td>");
printf("<td>$row[4]</td>");
printf("<td>$row[5]</td>");
printf("<td>$row[6]</td>");
echo "</tr>";
echo "</table>";
}
}
else
{echo "There where no documents found to match your criteria.";}
pg_close($conn);

I realize this is not the code that you suggested but its the only way I could get it to work this far.

amcgrath

Uhhh, i think oyu might have a problem here:

above your line: while($row = @pg_fetch_array($result,0)) put this: $tick = 0;

replace while($row = @pg_fetch_array($result,0)) with while($row = @pg_fetch_array($result,$tick++))

The way you have it now, it will never stop.

and please delete all those printf("<td>$row[1]</td>"); statements! First, the first index in an array is [0], not 1, so you'll skip the first. second, this would print out each index count(array) times, not what you want.

Again, replace all of this:
while($row = @pg_fetch_array($result,0))
{
printf("<td>$row[1]</td>");
printf("<td>$row[2]</td>");
printf("<td>$row[3]</td>");
printf("<td>$row[4]</td>");
printf("<td>$row[5]</td>");
printf("<td>$row[6]</td>");
echo "</tr>";
echo "</table>";
}

whith this:
$tick = 0;
while($row = pgfetch_array($result,$tick++)) {
printf("<td>$row[donorid]</td>");

}

trust me, it'll work.

amcgrath

ok... a "slight" correction: change pgfetch_array to @pg_fetch_array... then it'll work 😉