While loop question

[blackhat]

Hi

This is my code

<?php 
include "config.php";

    $get22 = "SELECT gid, rating FROM ratings ORDER BY rating DESC, votes DESC LIMIT 10";
    $result22 = @mysql_query($get22);
        
    while (list ($gid, $rating) = @mysql_fetch_row($result22))
    { 
         $get2 = "SELECT gName FROM games WHERE gId = $gid LIMIT 1";
        $result2 = @mysql_query($get2);    
                        
        while (list ($name) = @mysql_fetch_row($result2))
        { 
            if($seo_support == "1")
            { 
                if($seo_words == "1")
                {
                    $game_name2 = str_replace(" ", "_", "$name");
                    $stars = round($rating);
                    $digits = 10;

                    include "name_replace.php";

                    if ($i < $digits) {
                        echo "<b>0".$i++."</b>";      
                    }
                    else {
                        echo "<b>".$i++."</b>";  
                   }                                    
                        echo "<a href=\"./play-$gid-$game_name2.html\" class=\"blackLink\"> $name</a> - <img src=\"images/s$stars.png\" /><br />";

                } 
                    
                else 
                {
                    echo "<a href=\"./play-$gid.html\"> $name</a> - $rating<br /> \n ";
                } 
            } 

            else 
            { 
                echo "<a href=./index.php?action=play&id=$gid>$name</a>  - $rating<br>"; 
            } 
        }
    } 
?>

The problem is that the first result dont get a #. Look here for a live test
http://www.planetarcades.com/test.php


Thanks

[gavwvin]

try:

<?php
include "config.php";

    $get22 = "SELECT gid, rating FROM ratings ORDER BY rating DESC, votes DESC LIMIT 10";
    $result22 = @mysql_query($get22);
    $i = 1;
    while (list ($gid, $rating) = @mysql_fetch_row($result22))
    {
         $get2 = "SELECT gName FROM games WHERE gId = $gid LIMIT 1";
        $result2 = @mysql_query($get2);    
                        
        while (list ($name) = @mysql_fetch_row($result2))
        {
            if($seo_support == "1")
            {
                if($seo_words == "1")
                {
                    $game_name2 = str_replace(" ", "_", "$name");
                    $stars = round($rating);
                    $digits = 10;

                    include "name_replace.php";

                    if ($i < $digits) {
                        echo "<b>0".$i."</b>";      
                    }
                    else {
                        echo "<b>".$i."</b>";  
                   }
                   $i++                                 
                        echo "<a href=\"./play-$gid-$game_name2.html\" class=\"blackLink\"> $name</a> - <img src=\"images/s$stars.png\" /><br />";

                }
                    
                else
                {
                    echo "<a href=\"./play-$gid.html\"> $name</a> - $rating<br /> \n ";
                }
            }

            else
            {
                echo "<a href=./index.php?action=play&id=$gid>$name</a>  - $rating<br>";
            }
        }
    }
?>

[blackhat]

Thank you very much. That works excellent