While loop is skiping records

[dodgei]

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

[trq]

can we see a sample of the output? That code shouldn't possibly skipp any records.

[dodgei]

Thats weird, it shows skipped records when its in the browser but when I click to view the source code
all of the records are there.

Whats going on??

[Jessica]

You never close your link. Try this

[code=php:0]
echo '<a href="' . $_SERVER['PHP_SELF'] . '?action=delete&row_id='. $r->EntryID . '">delete</a>'."\n";
[/code]

[dodgei]

I get this error when I try that,

PHP Parse error: parse error, unexpected T_ECHO in C:\Inetpub\wwwroot\QualityInn\alpaha.php on line 11

I thought "/a" ended the link.

[trq]

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

[Jessica]

Yes but you never had the closing " on the href.
I don't see a problem with mine, but if escaping the double quotes works better, do that.

[dodgei]

Thrope,

I tried the correction you suggested and I get the same thing.

[Jessica]

echo $r->EntryID; <- does this line still have the ; on it, or did you erase it.

[trq]

Post your current code.

[dodgei]

[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]

[Jessica]

You don't have the ; on the end of the line.