$i loop with possible equal?!?

jmansa

I have this script which loops through a db table and list users depending on rank like this:

$sql="SELECT * FROM ".$prefix."_users ORDER BY rankpoints DESC";
$result = mysql_query($sql);

$i = 1;

while($row = mysql_fetch_array($result)){

   echo '<tr><td>'.$i.'</td><td>'.$row['username'].'</td><td>'.$row['rankpoints'].'</td></tr>';

}

Now this prints out something like this:
1 Peter Taylor 27
2 Tom Jones 27
3 Mark Hanson 24
..........
87 Mark Hanson 2

Now what I would like to do is when 2 user has the same amount of "rankpoints" the $i number should be like this:
1 Peter Taylor 27
1 Tom Jones 27
3 Mark Hanson 24
..........
87 Mark Hanson 2

Or:
1 Peter Taylor 27
- Tom Jones 27
3 Mark Hanson 24
..........
87 Mark Hanson 2

Can this be done?

dagon


$i = 1;

while($row = mysql_fetch_array($result)){
			$tmp = $row['rankpoints'];

if ($tmp != $row['rankpoints']) {
$i++;
}
  echo '<tr><td>'.$i.'</td><td>'.$row['username'].'</td><td>'.$row['rankpoints'].'</td></tr>'; 



}

devinemke

$result = mysql_query('SELECT * FROM ' . $prefix . '_users ORDER BY rankpoints DESC') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[$row['rankpoints']][] = $row['username'];}

$i = 1;

echo '<table border="1">';

foreach ($array as $key => $value)
{
	foreach ($value as $sub_value)
	{
		echo '<tr><td>' . $i . '</td><td>' . $sub_value . '</td><td>' . $key . '</td></tr>';		
	}

$i++;
}

echo '<table>';

jmansa

dagon;10908431 wrote:


$i = 1;

while($row = mysql_fetch_array($result)){
			$tmp = $row['rankpoints'];

if ($tmp != $row['rankpoints']) {
$i++;
}
  echo '<tr><td>'.$i.'</td><td>'.$row['username'].'</td><td>'.$row['rankpoints'].'</td></tr>'; 



}

Can't seem to get this to work... nothing happens?

devinemke;10908432 wrote:

$result = mysql_query('SELECT * FROM ' . $prefix . '_users ORDER BY rankpoints DESC') or exit(mysql_error());
while ($row = mysql_fetch_assoc($result)) {$array[$row['rankpoints']][] = $row['username'];}

$i = 1;

echo '<table border="1">';

foreach ($array as $key => $value)
{
	foreach ($value as $sub_value)
	{
		echo '<tr><td>' . $i . '</td><td>' . $sub_value . '</td><td>' . $key . '</td></tr>';		
	}

$i++;
}

echo '<table>';

This allmost works... It does give the users with the same rankpoints the same rank but doesn't skip the numbers to the next.

It shows up like this:
1
1
2

But should be like this:
1
1
3

Any ideas on that?

dagon

jmansa;10908444 wrote:
Can't seem to get this to work... nothing happens?

you did put in the result and sql line as well as the rest of the table?

jmansa

dagon;10908446 wrote:
you did put in the result and sql line as well as the rest of the table?

What it does it gives every user the rank 1... where it should in this example be 1,1,3...

Any idea?

dagon

move the count to the end, the logic is simply, increment the id if the current and previous rows are not the same

jmansa

Did you mean like this... Still the same... All gets the rank 1?

$i = 1; 

		while($row = mysql_fetch_array($result)){ 
					$tmp = $row['rankpoints']; 

		  echo '<tr><td>'.$i.'</td><td>'.$row['username'].'</td><td>'.$row['rankpoints'].'</td></tr>'; 

		}
		if ($tmp != $row['rankpoints']) { 
		$i++; 
		}

Salkcin

not sure if this works, just wrote it right here in the forum form, change your while() loop to this and see how it goes:

$x = 0;
$i = 0;
while($row = mysql_fetch_array($result)){

$curr = $row['rankpoints'];
if ($curr != $prev)
{
	$i = $x + 1;
}

echo '<tr><td>'.$i.'</td><td>'.$row['username'].'</td><td>'.$row['rankpoints'].'</td></tr>';
$prev = $curr;
$x++;

}

jmansa

Salkcin;10908453 wrote:
not sure if this works, just wrote it right here in the forum form, change your while() loop to this and see how it goes:
$x = 0;
$i = 0;
while($row = mysql_fetch_array($result)){

$curr = $row['rankpoints'];
if ($curr != $prev)
{
	$i = $x + 1;
}

echo '<tr><td>'.$i.'</td><td>'.$row['username'].'</td><td>'.$row['rankpoints'].'</td></tr>';
$prev = $curr;
$x++;

}

That does it, allthough with one error...
Undefined variable: prev in /mypage.php on line 103

Referring to: $prev = $curr;

How to remove that?!

Salkcin

change your code to this:

$x = 0;
$i = 0; 
$prev = 0;
while($row = mysql_fetch_array($result)){ 

... rest of the code here

jmansa

THANKS... Tthat did the job... Nice work :-)