help plz

[grant]

well av got on my login page the top 5 and its not showing them in the order wen some new comes in the game it knocks the other players out the top 5 how do i go about this so the other players stay on the list in till some 1 takes over them like if a was lvl 10 they wld need to get to lvl 11 to tale over me on the front page and in the orders from 1 to 5 top to bottom ? thanks any help on this wld be great :rolleyes:

[Danny696]

Let me point you too; http://makewebgames.io/board290/34204-english

[grant]

Let me point you too; http://makewebgames.io/board290/34204-english

in how is that going to help ? in any way ;(

[Jordan Palmer]

$player = $db->fetch_row($db->query('select userid, username, level from users order by level desc limit 5'));

That'll select USERID, USERNAME, AND USERS LEVEL from the users table, then order the results by level DESCENDING, then limits to 5 results.

Output would be ".$player['userid']."

[Danny696]

It'll enable people to read it :)

[Rasheed saeed]

@Danny:

Any need? Isn't really helping the reputation of MWG being 'helpful'..

[SilvaTungDevil]

expanding on jordan's a bit:

 

$r = $db->query("SELECT `userid`, `username`, `level` FROM `users`ORDER BY  level DESC LIMIT 5");

while ($ir = $db->fetch_row($r) )
{
echo ' '.$ir['username'] .' '.$ir['level'].' 
';
}

 

That will print out all 5 of your top users

[Danny696]

echo ' '.$ir['username'] .' '.$ir['level'].' 
';

OR

echo $ir['username'] .' '. $ir['level'].'
';

[grant]

expanding on jordan's a bit:

 

$r = $db->query("SELECT `userid`, `username`, `level` FROM `users`ORDER BY  level DESC LIMIT 5");

while ($ir = $db->fetch_row($r) )
{
echo ' '.$ir['username'] .' '.$ir['level'].' 
';
}

 

That will print out all 5 of your top users

thanks i had one but was show wrong ? 8o 8o 8o

[Rasheed saeed]

Just wondering, what have you select the user's ID if your not using it? :/

[SilvaTungDevil]

Thats a very good point rasheed, I only selected it because i used jordans piece.

However should he wish to make all the names links to the profiles, then the userid would come in handy other than that it should be removed

[Danny696]

If its on the login why would he make it link, they would just go back to the login :)

[Jordan Palmer]

I select userids because most output the userid. no biggie

[grant]

Parse error: syntax error, unexpected T_ENCAPSED_AND_WHITESPACE, expecting T_STRING or T_VARIABLE or T_NUM_STRING in /home/********/public_html/login.php on line 243 dont under stand y this is going like this av tryin just about everyfing i no :S lol

[The Monk]

Post your login.php, that way we can see what is on line 243 and help you fix it.