number sequence

[msnhockey]

looking at doing a different number sequence for rows

i have a page that displays 50 things.
it puts them in order of 1-50
i want to if 2 or more things are tied then the next row displays a different #

ie

1
2
2
2
5
6
7
7
7
10
11
12
and so on

any ideas on how to do this

thanks

[Horizon88]

Something close to this may work:

$last = null;
foreach ($yourList as $i) {
   if ($i == $last) {
     echo $last . '<br />';
   }
   else {
      echo $i . '<br />';
      $last = $i;
   }
}

[msnhockey]

tried using that and nothing so changed a few lines and still get what i get

here is the code from around where i use to get the 1-50 numbers

           for($i=1; $i<51; $i++)

		   {

            list ($key, $value) = each ($p_array);

$ppnum = ($i + 1);

[msnhockey]

i keep trying the code that was submitted, but can't get anything to work...
anyone have any ideas

[laserlight]

What is your current code?

[msnhockey]

this is the code that gets the # sequence for me now

for($i=1; $i<51; $i++)

{

list ($key, $value) = each ($p_array);

$ppnum = ($i + 1);

[laserlight]

this is the code that gets the # sequence for me now

Your code snippet is incomplete and does not print anything. I would expect a syntax error and notices about undefined variables. Post the smallest and simplest script that demonstrates the problem.

As for a solution consider:

<?php
// Use 1-based indices for this array.
$array = array(1 => 'a', 'b', 'b', 'b', 'c', 'd', 'e', 'e', 'e', 'f', 'g', 'h');

$last_index = 1;
for ($i = 1; $i <= count($array); ++$i)
{
    if ($array[$i] != $array[$last_index])
    {
        $last_index = $i;
    }
    echo $last_index . '<br />';
}
?>

[NogDog]

Here's what I came up with:

<table>
<tr><th>Place</th><th>Value</th></tr>
<?php
$values = array(1,1,2,3,3,3,4,5,6,6,6,7,8,8,9,9,9,10);
$counter = 0;
$place = 0;
$lastValue = null;
foreach($values as $value)
{
   $counter++;
   if($value != $lastValue)
   {
      $place = $counter;
   }
   $lastValue = $value;
   echo "<tr><td>$place</td><td>$value</td></tr>\n";
}
?>
</table>

Output:

Place	Value
1	1
1	1
3	2
4	3
4	3
4	3
7	4
8	5
9	6
9	6
9	6
12	7
13	8
13	8
15	9
15	9
15	9
18	10

[msnhockey]

i can get laserlights do display, but only 1 thing shows up.. not upto a possible of 50 names

[msnhockey]

here is what laserlights code displays for me
http://theufhl.com/?opt=leaguelead&sid=000000000004

the # column is the one to look at

[laserlight]

i can get laserlights do display, but only 1 thing shows up.. not upto a possible of 50 names

If you have that problem with my code, something is really wrong with your web server/PHP backend.

here is what laserlights code displays for me
http://theufhl.com/?opt=leaguelead&sid=000000000004

the # column is the one to look at

It looks fine to me, at least in the sense that more than one name shows up and the numbers appear to be running in the order you intended.

It is all very well to show what output you have, but if you do not also show the code, it is hard to tell what is wrong.

I repeat: Post the smallest and simplest script that demonstrates the problem.

[msnhockey]

laserlight..

your right the code you made displays as you intended for number sequencing. I guess i missed something to add.. the # sequence needs to be in juction with the points or what ever else is being sorted...

here is some of the code and includes the code that laserlight provided..

$array = array(1 => 'a', 'b', 'b', 'b', 'c', 'd', 'e', 'e', 'e', 'f', 'g', 'h');

$last_index = 1;

for ($i = 1; $i <= 51; $i++)








		   {

            list ($key, $value) = each ($p_array);




if ($array[$i] != $array[$last_index])
{
    $last_index = $i;
}







  //ROW COLOR

$tbgcolor = is_int($i / 2)?"#efefef":"#ffffff";






		                $stats .= ' 
<tr bgcolor="'.$tbgcolor.'" align="center">




            <td class="table_text">' . $last_index. '</td> 
            <td align="left" class="table_text"><a href="./?opt=viewplayer&pid='.$value['pid'].'&sid='.$sid.'&tid='.$value['tid'].'&divid='.$value['divid'].'"><b>'.$value['fname'].' '.$value['lname'].'</b>&nbsp;&nbsp;</a>'.$value1111;  

        if($value['status'] == 'Injured') 
        { 
            $stats .= '<img alt="'.$value['injurystatus'].'" src="http://www.theufhl.com/images/injury.gif" />'; 
        } 

        $stats .= ' 
            </td> 
            <td class="table_text"><a href="./?opt=viewteam&id='.$value['tid'].'&sid='.$sid.'&divid='.$value['divid'].'">'.$value['team'].'</a></td> 
         <td class="table_text">'.$value['position'].'</td>';

if($order == 'goals')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['goals'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['goals'].'</td>';

if($order == 'assists')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['assists'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['assists'].'</td>';

if($order == 'points' || $order == '')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['pts'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['pts'].'</td>';

[msnhockey]

here is all the code

<?php



function divstats($sid,$order) {











$result_season = mysql_query("SELECT name FROM seasons WHERE id = '".$sid."'");
$seasonname = mysql_result($result_season,0,"name");

$stats_sql = "SELECT * FROM player_stats,teams,players WHERE player_stats.seasonid = '".$sid."' AND "
	."teams.id = player_stats.team_id AND "
	."players.id = player_stats.playerid AND players.position != 'G'";

$result_stats = mysql_query("$stats_sql");
	if(!$result_stats) { echo mysql_errno().": ".mysql_error()."<br>"; }
$statcount = mysql_numrows($result_stats);





        $stats .= "
		<table width=\"90%\" bgcolor=\"#000000\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\">
	              <tr>
	              <td bgcolor=\"#000000\">
                           <table border=\"0\" width=\"100%\" cellpadding=\"2\" bordercolor=\"#000000\" cellspacing=\"1\">
		<tr align=\"center\" bgcolor=\"#efefef\">
		<td colspan=\"14\" class=\"table_header\"><font color=\"#000000\">PLAYER STATS</font></td>
		</tr>
                <tr bgcolor=\"#dfdfdf\" align=\"center\">
                <td class=\"table_header\">#</td>
		<td class=\"table_header\">Name</td>
                <td class=\"table_header\">Team</td>
                <td class=\"table_header\">Pos</td>
                    <td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=goals'><u>G</a></u></td>
                <td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=assists'><u>A</a></u></td>
                <td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=points'><u>PTS</a></u></td>";

        if($user_xtra1 == 1){
        $stats .= "<td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=xtra1'><u>$user_x1titles</a></u></td>";
        }
        if($user_xtra2 == 1){
        $stats .= "<td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=xtra2'><u>$user_x2titles</a></u></td>";
        }
        if($user_xtra3 == 1){
        $stats .= "<td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=xtra3'><u>$user_x3titles</a></u></td>";
        }
        if($user_xtra4 == 1){
        $stats .= "<td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=xtra4'><u>$user_x4titles</a></u></td>";
            }
        if($user_shotper == 1){
        $stats .= "<td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=shotper'><u>$user_shotpertitle</a></u></td>";
        }
        if($user_xtra5 == 1){
        $stats .= "<td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=xtra5'><u>$user_x5titles</a></u></td>";
        }

        $stats .= "
                <td class=\"table_header\"><a href='?opt=leaguelead&sid=$sid&order=pim'><u><!--%cc_pmin%--></a></u></td>
		</tr>";

while ($row = mysql_fetch_assoc($result_stats)) 
    {




            $i = 0;
            $sc = 0;

			$p_array = Array();

			while($sc < $statcount) {

$playerid = mysql_result($result_stats,$sc,"players.id");

$p_array[$playerid][goals] = $p_array[$playerid][goals] + mysql_result($result_stats,$sc,"player_stats.goals");

$p_array[$playerid][assists] = $p_array[$playerid][assists] + mysql_result($result_stats,$sc,"player_stats.assists");

$p_array[$playerid][pts] = $p_array[$playerid][pts] + mysql_result($result_stats,$sc,"player_stats.goals") + mysql_result($result_stats,$sc,"player_stats.assists");

$p_array[$playerid][minutes] = $p_array[$playerid][minutes] + mysql_result($result_stats,$sc,"player_stats.minutes");

$p_array[$playerid][xtra1] = $p_array[$playerid][xtra1] + mysql_result($result_stats,$sc,"player_stats.xtra1");

$p_array[$playerid][xtra2] = $p_array[$playerid][xtra2] + mysql_result($result_stats,$sc,"player_stats.xtra2");

$p_array[$playerid][xtra3] = $p_array[$playerid][xtra3] + mysql_result($result_stats,$sc,"player_stats.xtra3");

$p_array[$playerid][xtra4] = $p_array[$playerid][xtra4] + mysql_result($result_stats,$sc,"player_stats.xtra4");

$p_array[$playerid][shotper] = ROUND($p_array[$playerid][goals] / $p_array[$playerid][xtra4] * 100, 2); 

$p_array[$playerid][xtra5] = $p_array[$playerid][xtra5] + mysql_result($result_stats,$sc,"player_stats.xtra5");

$p_array[$playerid][gp] = $p_array[$playerid][gp] + 1;


$p_array[$playerid][gminutes] = $p_array[$playerid][gminutes] + mysql_result($result_stats,$sc,"player_stats.gminutes");



$p_array[$playerid][position] = mysql_result($result_stats,$sc,"players.position");
$p_array[$playerid][fname] = mysql_result($result_stats,$sc,"players.fname");
$p_array[$playerid][lname] = mysql_result($result_stats,$sc,"players.lname");
$p_array[$playerid][status] = mysql_result($result_stats,$sc,"players.status");
$p_array[$playerid][injurystatus] = mysql_result($result_stats,$sc,"players.injurystatus");
$p_array[$playerid][team] = mysql_result($result_stats,$sc,"teams.name");
$p_array[$playerid][teama] = mysql_result($result_stats,$sc,"teams.teama");

//Added next 3 lines for showing links for players and teams 10-14-05 MC

$p_array[$playerid][tid] = mysql_result($result_stats,$sc,"teams.id");
$p_array[$playerid][divid] = mysql_result($result_stats,$sc,"teams.division");
$p_array[$playerid][pid] = mysql_result($result_stats,$sc,"players.id");$sc++;

			}



		 		if ($order == "pts")
        uasort($p_array, 'Compare_stats');
	else if ($order == "goals")
		uasort($p_array, 'Compare_stats_g');
	else if ($order == "assists")
		uasort($p_array, 'Compare_stats_a');
	else if ($order == "pim")	
		uasort($p_array, 'Compare_stats_m');
            else if ($order == "xtra1")	
		uasort($p_array, 'Compare_stats_xtra1');
            else if ($order == "xtra2")	
		uasort($p_array, 'Compare_stats_xtra2');
            else if ($order == "xtra3")	
		uasort($p_array, 'Compare_stats_xtra3');
            else if ($order == "xtra4")	
		uasort($p_array, 'Compare_stats_xtra4');
            else if ($order == "xtra5")	
		uasort($p_array, 'Compare_stats_xtra5');
            else if ($order == "shotper")	
		uasort($p_array, 'Compare_stats_shotper');
	else
		uasort($p_array, 'Compare_stats');



$array = array(1 => 'a', 'b', 'b', 'b', 'c', 'd', 'e', 'e', 'e', 'f', 'g', 'h');

$last_index = 1;

for ($i = 1; $i <= 51; $i++)








		   {

            list ($key, $value) = each ($p_array);




if ($array[$i] != $array[$last_index])
{
    $last_index = $i;
}







  //ROW COLOR

$tbgcolor = is_int($i / 2)?"#efefef":"#ffffff";






		                $stats .= ' 
<tr bgcolor="'.$tbgcolor.'" align="center">




            <td class="table_text">' . $last_index. '</td> 
            <td align="left" class="table_text"><a href="./?opt=viewplayer&pid='.$value['pid'].'&sid='.$sid.'&tid='.$value['tid'].'&divid='.$value['divid'].'"><b>'.$value['fname'].' '.$value['lname'].'</b>&nbsp;&nbsp;</a>'.$value1111;  

        if($value['status'] == 'Injured') 
        { 
            $stats .= '<img alt="'.$value['injurystatus'].'" src="/images/injury.gif" />'; 
        } 

        $stats .= ' 
            </td> 
            <td class="table_text"><a href="./?opt=viewteam&id='.$value['tid'].'&sid='.$sid.'&divid='.$value['divid'].'">'.$value['team'].'</a></td> 
         <td class="table_text">'.$value['position'].'</td>';

if($order == 'goals')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['goals'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['goals'].'</td>';

if($order == 'assists')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['assists'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['assists'].'</td>';

if($order == 'points' || $order == '')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['pts'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['pts'].'</td>';

if($user_xtra1 == 1){
          if($order == 'xtra1')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['xtra1'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['xtra1'].'</td>';

                }

            if($user_xtra2 == 1){
            if($order == 'xtra2')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['xtra2'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['xtra2'].'</td>';

                }

            if($user_xtra3 == 1){
             if($order == 'xtra3')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['xtra3'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['xtra3'].'</td>';

                }

            if($user_xtra4 == 1){
             if($order == 'xtra4')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['xtra4'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['xtra4'].'</td>';
                    }
                if($user_shotper == 1){
                 if($order == 'shotper')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['shotper'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['shotper'].'</td>';
                    }

            if($user_xtra5 == 1){
             if($order == 'xtra5')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['xtra5'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['xtra5'].'</td>';

                }

if($order == 'pim')
$stats .= '<td class="table_text" bgcolor="#999999">'.$value['minutes'].'</td>';
	else
$stats .= '<td class="table_text">'.$value['minutes'].'</td>';



    } 











?>