[Dark_Wizard]

Yesterday at 08:11 AM Boofo said this in Post #5
You're pulling each part of this out of 2 different queries:

PHP Code:

$usergames[gameid] 


Can you do that?

Well I redid the whole thing and now it works except my alt rows look horrilbe...here is what I now have:

PHP Code:

maketableheader("Member Games");
  $result=$DB_site->query("SELECT * FROM vwar_games ORDER BY gamename ASC");
  while($game=$DB_site->fetch_array($result)) 
  {
    $result2=$DB_site->query_first("SELECT COUNT(membergamesid) FROM vwar_membergames 
      WHERE userid='$userid' AND gameid='".$game["gameid"]."'");
      echo "<tr class='".getrowbg()."'><td>".
      makeyesnocode("$game[gamename]","$game[gameid]","$result2[0]")."</td></tr>\n";
} 


Any ideas?