Re: Skipping a row

[Robby Russell <rrussell@xxxxxxxxxxxxxxxxx>]

John Greco wrote:
>  $sql2 = "select * from product where whseNum = '".$whseNumber."' order by
> prodNum";

What does your PHP code look like after that? What is your index 
starting with?

are you starting with 0? or 1?

$sql = "SELECT id FROM product WHERE something = this";
$rs = pg_query($sql);

$i = 0; //not needed, but to show what is is to start with

while ($i < pg_numrows($sql)) {
  print pg_fetch_result($rs, $i, id) . "\n";
  $i++;  // increment
}

// done

-Robby

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php