sqlsrv_fetch_array missing the first row
Posted: Tue Sep 27, 2011 10:01 pm
The following will print out 9 rows however there are acutually 10 rows in the fetch array. The first one is always missing. Any clue why it skips the first $row? Thank you.
// Fetch and print all the records....
$bg = '#99cccc';
while($row = sqlsrv_fetch_array($result)) {
$bg = ($bg=='#99cccc' ? '#ffffff' : '#99cccc');
echo '<tr bgcolor="' . $bg . '">
<td align="left">'. $row['LastName'] . '</td>
<td align="left">' . $row['ItemId'] . '</td>
<td align="left">' . $row['Description'] . '</td>
<td align="left">' . number_format($row['ListPrice'],2) . '</td>
<td align="left">' . $row['ItemStatus'] . '</td>
<td align="left">' . $row['DateTimePosted'] . '<br /></td>
</tr>
';
} // End of WHILE loop.
// Fetch and print all the records....
$bg = '#99cccc';
while($row = sqlsrv_fetch_array($result)) {
$bg = ($bg=='#99cccc' ? '#ffffff' : '#99cccc');
echo '<tr bgcolor="' . $bg . '">
<td align="left">'. $row['LastName'] . '</td>
<td align="left">' . $row['ItemId'] . '</td>
<td align="left">' . $row['Description'] . '</td>
<td align="left">' . number_format($row['ListPrice'],2) . '</td>
<td align="left">' . $row['ItemStatus'] . '</td>
<td align="left">' . $row['DateTimePosted'] . '<br /></td>
</tr>
';
} // End of WHILE loop.