PDA

View Full Version : Help with linking DB fields?


Impreza04
04-14-2006, 03:37 PM
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

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.

// ################################################## ##############
// ################## 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