# Recurring results

**URL:** https://forum.kirupa.com/t/recurring-results/204485
**Category:** Uncategorized
**Created:** [October 20, 2006, 3:01am UTC](https://forum.kirupa.com/t/recurring-results/204485 "2006-10-20T03:01:45Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![Flash\_Man1](https://avatars.discourse-cdn.com/v4/letter/f/8797f3/32.png) [@Flash\_Man1](https://forum.kirupa.com/u/Flash_Man1)
#### Post date: [October 20, 2006, 3:01am UTC](https://forum.kirupa.com/t/recurring-results/204485/1 "2006-10-20T03:01:45Z")

</div>

hey,

how would you go about having 10 results show up in 10 dynamic text fields all called name1,name2 etc here is my code and query:

```auto
$query = "SELECT * FROM leaderboard ORDER BY score DESC LIMIT 10";
$result = mysql_query($query);
$num = mysql_num_rows( $result );
$i = 1;

while($line = mysql_fetch_array($result)){
$name[$i] = $line['firstname'];
$score[$i] = $line['score'];
$i++;
}
for ($i=1; $i<=$num;$i++){
$text = $results . "&name$i=" . $name[$i] . "&score$i=" . $score[$i];
}
echo $text;
//print (mysql_error());

?>

```