Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 General Discussions
  #1  
Old 04-14-2006, 03:37 PM
Impreza04 Impreza04 is offline
 
Join Date: Jul 2005
Location: UK
Posts: 99
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default 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
Attached Images
File Type: jpg ScreenShot029.jpg (155.0 KB, 0 views)
File Type: jpg ScreenShot030.jpg (317.0 KB, 0 views)
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:29 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2024, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.04554 seconds
  • Memory Usage 2,192KB
  • Queries Executed 14 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)ad_showthread_beforeqr
  • (1)ad_showthread_firstpost
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)bbcode_php
  • (1)footer
  • (1)forumjump
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (3)navbar_link
  • (120)option
  • (1)post_thanks_box
  • (1)post_thanks_button
  • (1)post_thanks_javascript
  • (1)post_thanks_navbar_search
  • (1)post_thanks_postbit_info
  • (1)postbit
  • (2)postbit_attachment
  • (1)postbit_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper 

Phrase Groups Available:
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files:
  • ./showthread.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/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/functions_post_thanks.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_postinfo_query
  • fetch_postinfo
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • forumjump
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • post_thanks_function_post_thanks_off_start
  • post_thanks_function_post_thanks_off_end
  • post_thanks_function_fetch_thanks_start
  • post_thanks_function_fetch_thanks_end
  • post_thanks_function_thanked_already_start
  • post_thanks_function_thanked_already_end
  • fetch_musername
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • post_thanks_function_can_thank_this_post_start
  • tag_fetchbit_complete
  • forumrules
  • navbits
  • navbits_complete
  • showthread_complete