A count for loop!

Question

I have tried everything to get this to work and just cant get the count right.

                        <?php
                    $total = count($u);
                    for ($i = 0; $i < $total; $i++) 
                    {
                        $j = 0;
                        $s = $database->checkUserPlayedRecent($u[$i]);
                        if (mysql_num_rows($s) > 0)
                        {
                            $j = $j + 1;
                            ?>
                            <tr>
                                    <?php
                                        echo "<td>$j</td>";
                                    ?>

                                    <?php
                                        echo "<td>$u[$i]</td>";
                                    ?>
                                    <?php
                                        echo "<td>$p[$i]</td>";
                                    ?>
                            </tr>
                            <?
                        }
                    }
                    ?>

I am trying to increment $j each time but ONLY for the results from num_rows. Originally $j was $i + 1 but that wont work as I am not showing every result from the for loop, only those with num_rows returned. Any help here? Cheers

Answer 1

I would change your inner if to this:

                    if (mysql_num_rows($s) > 0)
                    {
                        $j = $j + 1;
                        ?>
                        <tr>
                                <?php
                                    echo "<td>$j</td>";
                                ?>

                                <?php
                                    echo "<td>$u[$i]</td>";
                                ?>
                                <?php
                                    echo "<td>$p[$i]</td>";
                                ?>
                        </tr>
                        <?
                    } else { // if no rows returned, hasn't played recently
                        echo "<tr><td>Hasn't Played</td></tr>";
                   }

At the moment, you're not accounting for no rows returned. Also, you may be able to avoid all the in-and-out of PHP by echoing or printing the whole thing in one shot. It's predictable enough that would be pretty simple.

Answer 2

 $total = count($u);
                    for ($i = 0; $i < $total; $i++) 
                    {
                        $j = 0;

$j assignment is inside the loop, so it's set to 0 every time. Just move it to right before the loop.

 $total = count($u);
                    $j = 0;
                    for ($i = 0; $i < $total; $i++) 
                    {