Double Query

[SmEdD]

Is there a way to keep from having to run the same query 2 times?

PHP Code:

    $games = $DB_site->query("
        SELECT * 
        FROM " . TABLE_PREFIX . "clan_game
        ORDER BY displayorder
    ");
    
    while ($game = $DB_site->fetch_array($games))
    {
        globalize($_POST, array("game_$game[gameid]", "game_$game[gameid]" . '_opt'));
        $gamenames .= ', roster.game_' . $game['gameid'];
    }
    unset($game);
    unset($games);
    
    $memberinfo = $DB_site->query_first("
        SELECT
        roster.memberid, roster.callsign, roster.firstname, roster.lastname, roster.birthday, roster.rank, roster.email, roster.status, roster.location,
        rank.title$gamenames
        FROM " . TABLE_PREFIX . "clan_roster AS roster
        LEFT JOIN " . TABLE_PREFIX . "clan_rank AS rank ON(rank.level = roster.rank)
        WHERE roster.memberid = $memberid
    ");

    // Generate Games
    $games = $DB_site->query("
        SELECT * 
        FROM " . TABLE_PREFIX . "clan_game
        ORDER BY displayorder
    ");
    while ($game = $DB_site->fetch_array($games))
    {
      $name = 'game_' . $game['gameid'];
      if ($memberinfo["$name"] == 1)
      {
        $memberinfo['games'] .= $game['title']  . '<br />';
      }
    } 


[Issvar]

Originally Posted by SmEdD

Is there a way to keep from having to run the same query 2 times?

PHP Code:

    $games = $DB_site->query("
        SELECT * 
        FROM " . TABLE_PREFIX . "clan_game
        ORDER BY displayorder
    ");
    
    while ($game = $DB_site->fetch_array($games))
    {
        globalize($_POST, array("game_$game[gameid]", "game_$game[gameid]" . '_opt'));
        $gamenames .= ', roster.game_' . $game['gameid'];

//Generate games
      $name = 'game_' . $game['gameid'];
      if ($memberinfo["$name"] == 1)
      {
        $memberinfo['games'] .= $game['title']  . '<br />';
      }
    }
    unset($game);
    unset($games);
    
    $memberinfo = $DB_site->query_first("
        SELECT
        roster.memberid, roster.callsign, roster.firstname, roster.lastname, roster.birthday, roster.rank, roster.email, roster.status, roster.location,
        rank.title$gamenames
        FROM " . TABLE_PREFIX . "clan_roster AS roster
        LEFT JOIN " . TABLE_PREFIX . "clan_rank AS rank ON(rank.level = roster.rank)
        WHERE roster.memberid = $memberid
    "); 


[Dean C]

vb3 hacking discussion is not allowed here - please wait until RC1 as we've stated on many occasions prior to this Thanks