[SOLVED] Individual Rank of each user

[affc]

Hello,

 

Just trying to display the number of each person individually from a table so that I can single out the individual rank for each person:

 

I get this error: Parse error: syntax error, unexpected T_LNUMBER, expecting T_VARIABLE or '$' at ((( $individualrank[]=$rank; )))

 

For some reason it wont let me get the rank of ++$rank so I can view each persons rank individually when I post a search result for that person.

 

Thanx in advance if anyone can help me here

 

<?php
$sql="SELECT * FROM $tbl_name ORDER BY TOTAL DESC, UserName ASC";
$result=mysql_query($sql);
$counter=mysql_num_rows($result);
$rank=0;
while($rows=mysql_fetch_array($result)){
++$rank;
$individualrank[]=$rank;
$Checkusername[]=$rows['UserName'];
}
for($i=0;$i<$counter;$i++){
if($Checkusername[$i]==$_POST['username']){
echo $$individualrank[$i];
}
}
?>

[Ken2k7]

You have an extra $ in your echo.

[affc]

Sorry that was actually just a personal error I have changed now but still no good, the error is coming from trying to get the number of each row using the ++

<?php
$sql="SELECT * FROM $tbl_name ORDER BY TOTAL DESC, UserName ASC";
$result=mysql_query($sql);
$counter=mysql_num_rows($result);
$rank=0;
while($rows=mysql_fetch_array($result)){
$individualrank[]=++$rank;
$Checkusername[]=$rows['UserName'];
}
for($i=0;$i<$counter;$i++){
if($Checkusername[$i]==$_POST['username']){
echo $individualrank[$i];
}
}
?>

[Ken2k7]

Is $tbl_name defined anywhere?

[affc]

Yeah, if I do the following I get this result:

 

<?php
while($rows=mysql_fetch_array($result)){
echo ++$rank;
echo $rows['UserName'];

?>
}

 

Result =

1 Peter

2 Tom

3 Garry

4 Sally

5 Gill

etc etc etc

 

but i dont want to echo all of them, only want to display 1 person I have searched for with the POST function but still show their rank etc.

[Ken2k7]

<?php
$sql="SELECT * FROM $tbl_name ORDER BY TOTAL DESC, UserName ASC";
$result=mysql_query($sql) or die(mysql_error());
$rank=0;
while($rows=mysql_fetch_array($result)){
++$rank;
if($rows['UserName']==$_POST['username']){
echo $rank;
}
}
?>

Like that?

[affc]

WOW!!!

 

lol, that is awesome. I am still getting my head around how that actually works but thank you so much. Wish I was that smart at php, still learning lol but thank you so much