Finding Overall Position

[Zepo.]

Ok i want to find the rank or position of a member based on their points. How would i do this?

[darkfreaks]

<?php

$member_points= $_GET['memberpoints'];

if($memberpoints=>whatevernumberhere) { //dostuff
}


elseif ($memberpoints=<whatevernumberhere) { //dostuff
}?>

[Zepo.]

That wont work because i need to pull points from the database of id=$member[id] and i need to find the position of that member based on points. Example

 

ID 1 - 50 points

ID 2 - 24 Points

ID 3 - 100 Points

 

And $member[id] =3 Then the rank would output 1 and if it was id 2 it would output 3 ect.

[soycharliente]

<?php
$sql = "SELECT * FROM `members` ORDER BY `points`";
$result = mysql_query($sql) OR DIE (mysql_error());
if (mysql_num_rows($result))
{
$rank = 0;
while ($row = mysql_fetch_array($result))
{
	$rank++;
	if ($row['id'] == $id)
	{
		exit(); // or is it break() ???
	}
}
}
?>

[Zepo.]

Thank you very much charlie =]. Your a life saver lol.

[Zepo.]

One problem, exit closes everything after it and break doesn't do anything..

[darkfreaks]

change exit() to mysql_close()

 

[soycharliente]

That's why they pay me the big ... bucks ...... wait.

 

I honestly don't know how exit() and break() work in a while loop. I suggest reading up on both to make sure you get the desired effect. One might stop the whole page from running while the other just exits the loop.

 

exit — Output a message and terminate the current script.

break — Ends execution of the current for, foreach, while, do-while or switch structure.

 

Sounds like break is a better choice.

 

 

 

change exit() to mysql_close()

The exit() was to jump outside the while loop, not close the db connection. I didn't add any information about connecting or closing on purpose.

[Zepo.]

I did try break but it gives me this,

Parse error: syntax error, unexpected ')' in /home/zepo/public_html/development/v22/index.php on line 1108

That is the line with the break..

[darkfreaks]

break;  not break()

[soycharliente]

DELETED. Irrelevant.

[soycharliente]

break;  not break()

 

Oh wow. I'm really dumb. No excuses. I'm sorry for telling you wrong syntax.

[darkfreaks]

no problem mate just a correction

[Zepo.]

NVM, changed to order by points DESC and it all works, thanks again. Works perfectly =].

[soycharliente]

Post a little more code.

 

Where is $member[id] coming from?

 

I picked a random table name and a random field name that sounded like what you needed. Is the database setup like that?

 

Echo the query to see exactly what it's pulling.

[soycharliente]

Did you change your post? LOL

 

Little errors are the worst. Mark solved please.

[darkfreaks]

hit solved topic shud be in left corner