Populate array from while loop to return PHP

Question

Hi im trying to populate an array with indexes like 'user1' and 'score1' to return to a function.

My Code: It comes up with unindentified variable errors

$query = 'select * from users order by score desc';
$result = mysql_query($query) or die (mysql_error());
$highscore = array();
$count = '0';

while($row = mysql_fetch_array($result))
{
    $count++;         
    $highscore = array('user' . $count => $row['username'], 'score' . $count => $row['score']);
}

return $highscore;

Lix · Accepted Answer · 2012-05-23 22:37:20Z

2

You should use numeric values when you want to use them.. You used a string representation of zero ('0')

$count = 0;
$highscore = array();
while($row = mysql_fetch_array($result))
{       
    $count++; 
    $highscore['user' . $count] = $row['username'];
    $highscore['score' . $count] = $row['score'];
}

answered May 23, 2012 at 22:37

Lix

48.2k12 gold badges107 silver badges134 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Gareth Over a year ago

Won't that give an array of arrays?

Lix Over a year ago

@gar - true true - my keyboard got away from me for a second there :P

Mark1inLA · Accepted Answer · 2012-05-23 22:42:20Z

0

If you wanted 'high score' you might want to use max and just return 1 row.

answered May 23, 2012 at 22:42

Mark1inLA

1961 silver badge7 bronze badges

2 Comments

Lix Over a year ago

What if it is the users own personal high score?

user140291 Over a year ago

@lix the query could easily be altered 'SELECT max(score) FROM users WHERE username = 'lix' but he has said that he requires it for a function, presumably to populate a table.

Collectives™ on Stack Overflow

Populate array from while loop to return PHP

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related