Re: [PHP-DB] Skipping a row

[Robby Russell]

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