Go Back   vb.org Archive > vBulletin 3 Discussion > vB3 Programming Discussions
FAQ Community Calendar Today's Posts Search

Reply
 
Thread Tools Display Modes
  #1  
Old 07-20-2006, 06:58 AM
aggiefan aggiefan is offline
 
Join Date: Apr 2005
Posts: 169
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default Capturing the selected value

I have the following code in my php file. The code creates a dropdown in my template of all the teams in the vbcontest_teams_ncaafootball database. I want it to capture the selected team and write it to a different table in the database. If I include the write to db part inside the while loop -- it writes all 12 options (so you can't tell what was selected. If you put it outside of the while loop, it writes a blank. Any ideas on what needs to be there to capture the selected value in the dropdown? See the screenshot if it helps you visualize it.

Code:
if ($_GET['action'] == "createweek")  {
 
$query_teams=$vbulletin->db->query('select team_name from ' . TABLE_PREFIX . 'vbcontest_teams_ncaafootball'); 
 $teams='';
 while($tea=$vbulletin->db->fetch_array($query_teams)){
 $selected='';
 if(@$_REQUEST['team_name']==$tea['team_name'])
 $selected=' selected';
 $teams.="<option value=\\\"".$tea['team_name']."\\\"$selected>".$tea['team_name']."</option>";
 
$errormessage = "<center>Congratulations!  You have successfully created your contest.  You can now advance to creating weeks.  Click below to begin or use the navigation in the adminCP.<br><br><a href=/forums/admincp/contestv2admin2.php?action=createweek>Click here to continue on and create a week for your contest</a href>";
$answerall = true;
}
if ($_POST['action'] == "submit") {
  if ($num == '5)
  {
     $errormessage = "$vbulletin->userinfo[username], you have 5 contests in the database already.  Please delete one before continuing.  Maintaining your contests will provide for quicker queries and better results for your users.";
  eval('print_output("' . fetch_template('STANDARD_ERROR') . '");');
     exit();
  } 
 eval('$formsend = "' . fetch_template('vBContestanswers') . '";');
$db->query_write("INSERT INTO " . TABLE_PREFIX . "vbcontest_teams_ncaafootball (`team_name`) VALUES ('\\\"".$tea['team_name']."\\\"$selected')");
 
}
Attached Images
File Type: jpg helpme.jpg (60.1 KB, 0 views)
Reply With Quote
Reply


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 09:57 AM.


Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.05057 seconds
  • Memory Usage 2,179KB
  • 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_code
  • (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
  • (1)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_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