vb.org Archive - Shouldn't be to hard!

My problem is that the games only come up for the first person and not any others. If I put the games query inside the wile it runs needless queries. How do I fix this. A Screen shot and the code is below!

PHP Code:


		
			
// ###################### Start list #######################

if ($_REQUEST['do'] == 'list')

{

    $applicants = $DB_site->query("

        SELECT *

        FROM " . TABLE_PREFIX . "clan_recruitment

        ORDER BY submitdate desc, callsign

    ");

    

    if ($DB_site->num_rows($applicants))

    {

        print_form_header('clanrecruitment', 'ranks');

        print_table_header($vbphrase['recruitment_manager'], 5);



        echo "

            <col width=\"100%\" align=\"$stylevar[left]\"></col>

            <col align=\"center\" style=\"white-space: nowrap\"></col>

            <col align=\"center\" style=\"white-space: nowrap\"></col>

            <col align=\"center\" style=\"white-space: nowrap\"></col>

            <col align=\"center\" style=\"white-space: nowrap\"></col>

        ";



        print_cells_row(array(

            $vbphrase['applicant'],

            $vbphrase['submit_date'],

            $vbphrase['email'],

            $vbphrase['games'],

            $vbphrase['controls']

        ), 1, '', -1);



        $games = $DB_site->query("

            SELECT * 

            FROM " . TABLE_PREFIX . "clan_game

            ORDER BY displayorder

        ");



        while ($applicant = $DB_site->fetch_array($applicants))

        {

            if ($DB_site->num_rows($games))

            {

                while ($game = $DB_site->fetch_array($games))

                {

                    if ($applicant["game_$game[gameid]"] == 1)

                    {

                        $applicant['games'] .= "$game[title]<br />";

                    }    

                }

            }

            $cell = array();

            $cell[] = "$applicant[firstname] <strong>\"$applicant[callsign]\"</strong> $applicant[lastname]";

            $cell[] = vbdate($vboptions['dateformat'], $applicant['submitdate'], true);

            $cell[] = $applicant['email'];

            $cell[] = $applicant['games'];

            $cell[] = construct_link_code($vbphrase['view'], "clanrecruitment.php?$session[sessionurl]do=view&amp;recruitmentid=$applicant[recruitmentid]") . construct_link_code($vbphrase['delete'], "clanrecruitment.php?$session[sessionurl]do=remove&amp;recruitmentid=$applicant[recruitmentid]");

            print_cells_row($cell);

        }



        print_table_footer();

    }

    else

    {

        print_stop_message('no_clan_members_defined');

    }

}

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01014 seconds Memory Usage 1,743KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_php_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (5)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: