foreach headaches

[TheServant]

Hey guys,
I am trying to generate a table automatically, but I am having headaches using foreach loops:

    $raw_user_rankings = mysql_query("SELECT user_id, user_name, user_clan_id, user_pop, user_race
                                    FROM users
                                    LIMIT 120, 30
                                    ");
    $user_rankings = mysql_fetch_array($raw_user_rankings);
 
    foreach ( $raw_user_rankings as $rank ) {
        echo("    <tr>
                    <td>" . ($i/5) . "</td>
                    <td><a href=\"profile.php?id=" . $rank['user_id'] . "\">" . $rank['user_name'] . "</a></td>
                    <td>" . $rank['user_clan_id'] . "</td>
                    <td>" . $rank['user_pop'] . "</td>
                    <td>" . ucwords($rank['user_race']) . "</td>
                </tr>
            ");
    }
 

This is probably one of the first times I've actually used a foreach loop in php and I can't figure out why I keep getting errors including:

Invalid argument supplied for foreach()

Can anyone explain this to me?

[Dormilich]

$raw_user_rankings is a resource, you probably meant

foreach ($user_rankings as $rank)

[TheServant]

@Dormilich

Sorry, I forgot to mention it, but going on that path I do get a result. It seems to be printing a table like:

Rank         Name         Clan         Population         Race                               
0                     0                     0                     0                     1                                            
0 0                     0                     0                     1                                                   
0                     s                     e                     r _

Which is really weird?

Also, printing the arrays I get for example:

Array (     [0] => 00001     [user_id] => 00001     [1] => user_1     [user_name] => user_1     [2] =>      [user_clan_id] =>      [3] => 0     [user_pop] => 0     [4] => human     [user_race] => human )

Which is all correct, but when I use:

echo($rank[0]);

I get "0"?

I think it's also not collecting the next row, so it is just repeating the first called one, which is why I tried to use the resource...

[TheServant]

OK I tried:

foreach ( $user_rankings as $rank ) {
print_r($rank);
}

And got:

0000100001user_1user_100humanhuman

Which suggests that the table I printed before is from that line and it was simply taking the character at position x where I had $rank[x]...

So what am I doing wrong?

[edit]***
Just started using a while loop instead which is the way I am used to, but I just thought a foreach loop would work. Anyway, problem solved by using another method. Thanks for your help.

[Dormilich]

@TheServant
mysql_fetch_assoc() only fetches one row at a time, that's why usually a while loop is used to get all the results.

if you want to fetch all results at once, have a look at PHP's database extensions (PDO, MySQLi, MDB2).

[TheServant]

That makes sense. Thanks for clearing that up for me.