vb.org Archive - Help with linking DB fields?

Sorry.. I couldn't come up with a better title..

What I want to do is to use an ID (gameid) in one table (lapsdb_laps).
But when it displays, it links gameid with game_id in another table (lapsdb_games) and use the relevant game_name field.

That doesn't really make sense since I really am blagging my way through this..
The screenshots may help

Attachment 45660
This shows what it currently does, as in shows the ID and not a name..
The problem im having is getting it to find the name in another table and display that instead.

PHP Code:


		
			
// ################################################################

// ################## Now view submitted Laps #####################

// ################################################################

if ($_REQUEST['do'] == "viewlaps") {

print_cp_header("All Lap Times");

print_form_header('lapsdb_admin', '');

print_table_header("Edit Delete Lap Times",10);

        print_cells_row(array(

        "<b>Lap ID</b>",

        "<b>Game ID</b>",

        "<b>Car ID</b>",

        "<b>Track ID</b>",

        "<b>Lap Time</b>",

        "<b>Submitter</b>",

        "<b>Verified</b>",

        "<b>Comments</b>",

        "<b>Edit</b>",

        "<b>Delete</b>",),'thead','','',1);

        

    $get_laps = $db->query("SELECT * FROM ".TABLE_PREFIX."lapsdb_laps order by lap_id");

    while($laps = $db->fetch_array($get_laps))

    {



    

            print_cells_row(array(

            "<b>{$laps['lap_id']}</b>",

            "{$laps['gameid']}",

            "{$laps['carid']}",

            "{$laps['trackid']}",

            "{$laps['lap_time']}",

            "{$laps['submitter']}",

            "{$laps['verified']}",

            "{$laps['comments']}",

            "<a href='?act=editcheat&cheatid={$cheats['cheatid']}'>Edit</a>",

            "<a href='?act=deletecheat&cheatid={$cheats['cheatid']}'>Delete</a>"),

             '','','',1);

    

    }

    exit;



}

Any help is appreciated, but Ill understand if what im asking doesn't make much sense

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.00973 seconds Memory Usage 1,728KB 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 (1)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: