PHP's little secret - NEED TO KNOW MORE

[Anon]

Hi,

First off - THis is NOT a MySQL issue, it is PHP - Ok, sorry about that little out-burst!!

I have a PHP script that is keeping secrets from me, and it lies badly - see it tells me that 5 records were returns from the MySQL database.

But the while loop in PHP is only doing 4 of the records and it would appear record 2 is NOT displayed Record [1] if you look at this as an array.

here is some code snippets.

First the MySQL select statement...

$query_rsAccountList = "SELECT * FROM account_details ORDER BY account_details.signup_date DESC";
$rsAccountList = mysql_query($query_rsAccountList, $Sales) or die(mysql_error());
$row_rsAccountList = mysql_fetch_assoc($rsAccountList);
$totalRows_rsAccountList = mysql_num_rows($rsAccountList);

Now the PHP that echos to the screen...

<?php while ($row_rsAccountList = mysql_fetch_assoc($rsAccountList)){ ?>
<tr>
<td nowrap><a href="?accdet=<?php echo $row_rsAccountList['acc_tid'] ?>"><?php echo $row_rsAccountList['acc_id']; ?></a></td>
<td nowrap><?php echo $row_rsAccountList['name']; ?></td>
<td nowrap>&nbsp;</td>
<td nowrap>&nbsp;</td>
<td nowrap>&nbsp;</td>
<td nowrap><?php echo $row_rsAccountList['signup_date']; ?></td>
</tr>
<?php }; ?>

If anyone sees any error in either snippet, please let me know.

Thank you!

[Anon]

You execute the query (mysql_query).
You fetch the first row (mysql_fetch_assoc).
You check to see how many rows were selected (mysql_num_rows).
You fetch the remaining rows and display them (while ($row_rsAccountList = mysql_fetch_assoc...)

But you never did anything with the first row you fetched...

$rsAccountList = mysql_query($query_rsAccountList, $Sales) or die(mysql_error());
$row_rsAccountList = mysql_fetch_assoc($rsAccountList);
$totalRows_rsAccountList = mysql_num_rows($rsAccountList);

Now the PHP that echos to the screen...

<?php while ($row_rsAccountList = mysql_fetch_assoc($rsAccountList)){ ?>
<