Jump to content

While loop is skiping records


dodgei

Recommended Posts

This loop is skipping every other record. Why is that?

When I sort the records ascending it retrieves the odds. When I sort descending it retrieves the evens.

Here is the code.
[code]<?php

$odbc = odbc_connect ('accounting', 'root', '') or die('Could    Not Connect to ODBC Database!');
$sql = "select * from entry order by EntryID ASC";
  $results = @odbc_exec($odbc, $sql) or die("<tt>problem with $sql : " . odbc_errormsg() . "</tt>\n");

while($r = @odbc_fetch_object($results))
{

  echo $r->EntryID;
  echo "<a href=\"" . $_SERVER['PHP_SELF'] . "?action=delete&row_id=" . $r->EntryID . ">delete</a>\n";
}
odbc_close($odbc);
?>[/code]


Out put is :
1delete 3delete 5delete 7delete 9delete 11delete 13delete 15delete
Link to comment
https://forums.phpfreaks.com/topic/35600-while-loop-is-skiping-records/
Share on other sites

[code]
<?php

$odbc = odbc_connect ('accounting', 'root', '') or die('Could    Not Connect to ODBC Database!');
$sql = "select * from entry order by EntryID ASC";
  $results = @odbc_exec($odbc, $sql) or die("<tt>problem with $sql : " . odbc_errormsg() . "</tt>\n");

while($r = @odbc_fetch_object($results))
{

  echo $r->EntryID;
  echo "<a href=\"{$_SERVER['PHP_SELF']}?action=delete&row_id={$r->EntryID}\">delete</a>\n"

}
odbc_close($odbc);
?>[/code]

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.