Tell me more ×
Stack Overflow is a question and answer site for professional and enthusiast programmers. It's 100% free, no registration required.
up vote 0 down vote favorite

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;
share|improve this question

2 Answers

up vote 1 down vote

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'];
}
share|improve this answer
Won't that give an array of arrays? – Gareth May 23 '12 at 22:38
@gar - true true - my keyboard got away from me for a second there :P – Lix May 23 '12 at 22:40
up vote 0 down vote

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

share|improve this answer
What if it is the users own personal high score? – Lix May 23 '12 at 22:50
@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. – Jamie May 23 '12 at 22:53

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.