unable to jump

[trooper]

i have a slight problem with postgresql and php.

the following is code that throws out an error

case "delete_article":
$SQL = "SELECT id,file FROM downloads WHERE urid ='$urid'";
$result = pg_exec($db_conn,$SQL);
$num_rows = pg_numrows($result);
$row =0;
while($row < $num_rows)
{
$data = pg_fetch_array($result,$row);$download_id[$row] = $data[id];
$result = pg_exec($db_conn,"DELETE from downloads WHERE id
='$download_id[$row]'");
$result1 = pg_exec($db_conn,"DELETE FROM innovations WHERE id ='$news_id'");
$row++;
}
header("Location:index.php");
break;

the error it throws out is

$data = pg_fetch_array($result,$row);

i have racked my brains trying to work it out but to no avail.

What have i done wrong ?!??!?!?!

please help out

Thanks in advance

GM
Warning: Unable to jump to row 1 on PostgreSQL result index 11 in /usr/local/apache/htdocs/scam/blank/news/innovations/view/edit.php on line 147

line 147 is the

[trooper]

adendum to this issue

this is the correct code that is giving me trouble the first one i posted is not the correct file

case "delete_article":
$SQL = "SELECT id,file FROM downloads WHERE urid ='$urid'";
$result = pg_exec($db_conn,$SQL);
$num_rows = pg_numrows($result);
$row =0;
while($row < $num_rows)
{
$data = pg_fetch_array($result,$row);
$download_id = $data[id];
$result = pg_exec($db_conn,"DELETE from downloads WHERE id ='$download_id'");
$row++;
}
$result1 = pg_exec($db_conn,"DELETE FROM innovations WHERE id ='$news_id'");
header("Location:index.php");
break;

cheers

GM