[SOLVED] noob error...but help my php lookup

[marklarah]

<td bgcolor="darkgreen"><font color="white" align="center"><center>Recent Posts</center></font></td></tr>



<?php
$resultll="SELECT * FROM `topics` ORDER BY lpt DESC LIMIT 5";
$articlesll = mysql_query($resultll) or die(mysql_error());
$rrow = mysql_fetch_array($articlesll);








while ($rrow = mysql_fetch_array($articlesll)){
$rtopic = $rrow['name'];
?>

<tr>
<td><? echo $rtopic; ?>hi</td></tr>
<?
}
?>
</table>

 

It just echos hi....4 times rather than 5

[cooldude832]

I don't see a limit saying it will do it 5 times I see a limit of a max of 5 times maybe you only have 4 rows in your table

[GingerRobot]

Remove this line:

 

$rrow = mysql_fetch_array($articlesll);

 

You should not make a call to any of the mysql_fetch_xxx functions prior to using them in a loop. When you call this function, you move the pointer forward. Next time it's called, it points to the second row in the returned result.

 

[marklarah]

well it echos 5 times now as it should, but it still only echos hi.

[themistral]

Does the field 'name' exist in the table 'topics'?

[marklarah]

im not THAT noobish

[marklarah]

but i am noobish enough to forget case......  ;D

[GingerRobot]

That was my next question. Dont worry though, tis always the small things that catch you out.