Function Help

[Whitey]

Well the system i have made is you can add new main games.. so i am trying to make it generate on its own..

[John]

Exactley. Hence the for loop:

PHP Code:

for($i = 0; $i <= $max; i++)
{
    $q2 = "SELECT `id` FROM `Members` WHERE `maingame` = '".$row[$i]."'";
    $result2 = mysql_query($q2);
    echo $row[$i] . "-->" . mysql_num_rows($result);
} 


$row[$i] is the game id (in the previous post I statically set $row[$i] = 1). However, $row is an array of game id's which are dynamically generated upon request. The for loop circulates through the entire array of game id's and calculates the amount of members have have the game id, $row[$i], as their main game.

[Whitey]

PHP Code:

$q1 = "SELECT `id` FROM `{$dbprefix}GamesPlayed`";
$result = mysql_query($q1);
$row = mysql_fetch_array($result);
$max = count($row);

for($i = 0; $i <= $max; i++)
{
    $q2 = "SELECT `id` FROM `{$dbprefix}members` WHERE `maingame` = '".$row[$i]."'";
    $result2 = mysql_query($q2);
    echo $row[$i]; 
    echo "-->"; 
    echo mysql_num_rows($result2);
} 


This wouldn't work..
I tried it in the sql and it came up blank as well..
why would we select Id from members? the maingame is indeed a number
and we need to set the maingame = the id from gamesplayed..
see it gets confusing..

when i put this in my phpmyadmin
SELECT maingame, COUNT('1') FROM {$dbprefix}members GROUP BY maingame

it comes up with 5
wich is correct.. so my function has the right format is just has an error somewhere!

[John]

Originally Posted by Whitey

why would we select Id from members? the maingame is indeed a number
and we need to set the maingame = the id from gamesplayed..
see it gets confusing..

You can select anything from members, you just need to select something to count. If you want to PM me your SQL dump I can play with it locally. I'm sure I can come up with a solution.

[Whitey]

my function updated..
it shows the games.. but the count is messed up.

it comes out for every game 1 as the count.
here is the code

PHP Code:

function getGameStats()
{
global $dbprefix;
$query = "SELECT * FROM {$dbprefix}gamesplayed";
$result = mysql_query($query)
     or die(mysql_error());
echo '<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>';
for ($i = 0; $i < mysql_num_rows($result); $i = $i + 1)
{
    $gamepic = mysql_result($result, $i, "gamepic");
    $gamename = mysql_result($result, $i, "gamename");
    $id = mysql_result($result, $i, "ID");
        $query1 = "SELECT 'id' FROM {$dbprefix}members WHERE maingame = $id";
        $result1 = mysql_query($query1) or die(mysql_error());
            $stat = mysql_num_rows($result1);
            $stat = count($stat);
                echo ("<td><div align='center'><img src='$gamepic' alt='$gamename'> $stat</div></td>");
        
}
echo '  </tr>
</table>';
}