Multiple Returns - Not working correctly

[Anon]

Hi, I have some code... see below

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

that would appear to be working fine, if I never knew better, but it is failing to return one record for some reason, I have the RecordSet get ALL entries in the table, and it tells me it selected 5 records, but only prints 4 to the screen. How do i get the 5th record on screen? I have tried changiong the where clause to:

<?php while ($row_rsAccountList = mysql_fetch_assoc($rsAccountList)) || ($row_rsAccountList = mysql_fetch_assoc($rsAccountList, +1)) { ?>

With no joy!

Any ideas???

Regards,
Charlie

[Anon]

Database questions should be posted in the database forum!

[Anon]

Well that's the question - is it a DB question, the SQL is finding 5 records which is CORRECT, but PHP is not displaying all 5 records. PHP is only printing 4 of them to the screen, yet PHP tells me there are 5 records found.

So I ask again, can anyone see anything wrong with the PHP Code?

Has anyone here had/heard of a simular thing and know of a solution?

Thank you!

[Anon]

I think i see where you may be thinking I am asking an SQL question, where I said 'I have tried changiong the where clause to:' - I ment to say 'I have tried changing the while clause to:' which is PHP.

For this I appologise. I am asking a PHP question, the SQL is working fine.

Thank you,
Charlie