Re: Skipping a row

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