display different user in rank

[canabatz]

Hello .

i got a list of user with ranking . i want to display the first five places where it is not the same user, like that

john : is rank 1
john
john
david : is rank 2
albert : is rank 3
albert
john <========== he is allready rank at 1 ,so is out of the list
john <========== he is allready rank at 1 ,so is out of the lis
eric : is rank 4
sam : is rank 5

there is 5 place ,5 winners ,winner cannot be in more then one place.

any help please ,thanx!!

[Dormilich]

that depends on the type of list. if it’s fetched from DB you can use SELECT DISTINCT, if it’s an array you can use array_unique() (to name 2 possibilities)

[canabatz]

and how can i limit the result to 5 users only?

i cannot use limit on that select.

thanx

[Markus]

Use array_unique() and then array_slice().

$arr = array(
    1, 1, 2, 2, 3, 3, 4, 4, 5, 5
);
 
print_r(array_slice(array_unique($arr), 0, 4));
 

[canabatz]

im trying to put the array in a loop ,and it is not working for me ,i get only one result!

this is the code im trying to work on:

$sqlhis="select *  from bidding_details where bid_id=$bid_id and sortbid = '1' order by  bid_price desc ";
$queryhis=mysql_query($sqlhis);
 
while ($rowhis=mysql_fetch_array($queryhis)){
$username=$rowhis['username'];
 $arr = array(
   $username 
);
 
}  
 
$arr=(array_slice(array_unique($arr), 0, 5));
 
echo $arr[0] . "<br />";
echo $arr[1] . "<br />";
echo $arr[2] . "<br />";
echo $arr[3] . "<br />";
echo $arr[4] . "<br />";

any idea , im new in this php world :)

thanx

[Dormilich]

use

$arr[] = $username;

currently you’re overwriting your variable each time.

note: this is where Database Abstraction Layers come in handy, they (some) allow you to get the result array at once.

[canabatz]

thanx alot man ,that fixed my work!! tahnx to all that helped !!!


it's perfect :)