View Single Post
  #1  
Old 07-23-2008, 03:37 AM
AsscBB AsscBB is offline
 
Join Date: Dec 2007
Posts: 20
Благодарил(а): 0 раз(а)
Поблагодарили: 0 раз(а) в 0 сообщениях
Default How do I make a Variable Lenght Combobox/Dropdown menu?

I'm trying to build a user input form which takes the userid and runs a query. The results from the query are then put in a dropdown menu for the user to make a selection. Visually, I have this working just right, but the problem is the data is not being captured. I'm trying to tweak the Form Hack by Abe1 https://vborg.vbsupport.ru/showthread.php?t=126676 so that the dropdown isn't a static length.

I'm working with 2 templates and php code. The first template has the general page layout, and the second template has the section of code which is looped. The section of the main form template which drives the dropdown is:

HTML Code:
<tr>
<td class="alt1" valign="middle">
<b>$dropdownquestion1</b>:
</td>
<td class="alt1" valign="middle" colspan="2">
<select name="dropdownanswer1">

$dropdownresult

</select></td>
</tr>
The template file which was created to drive the dropdown options is:


combobox_options:
HTML Code:
<option value="$dropdownchoice[$key]" <if condition="$dropdownchoice[$key] == $dropdownanswer1">selected="selected"</if>>$dropdownchoice[$key]</option>


$dropdownresult is built in the php file using:

PHP Code:
$get_myvars=$db->query_read("   
    SELECT myvar
    FROM " 
TABLE_PREFIX "my_table
    WHERE    
    userid = 
$this_user 
"
);    

$option_number 1
while (
$get_myvar=$db->fetch_array($get_myvars))    

    
$dropdownchoice[$option_number] = $get_myvar[myvar]; 
    
$option_number++; 
}

foreach (
$dropdownchoice as $key => $value

    eval(
'$dropdownresult .= "' fetch_template('combobox_options') . '";'); 



Now my problem is being able to capture the result from the dropdown menu. As I said, it displays the results of the query as desired, and the user can manipulate the menu to select a value, but the form does not capture that into a variable for use. Can anyone help???


Thanks!
Reply With Quote
 
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01086 seconds
  • Memory Usage 1,781KB
  • Queries Executed 11 (?)
More Information
Template Usage:
  • (1)SHOWTHREAD_SHOWPOST
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_html
  • (1)bbcode_php
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)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_onlinestatus
  • (1)postbit_wrapper
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • reputationlevel
  • showthread
Included Files:
  • ./showpost.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
  • showpost_start
  • bbcode_fetch_tags
  • bbcode_create
  • postbit_factory
  • showpost_post
  • 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_display_complete
  • post_thanks_function_can_thank_this_post_start
  • showpost_complete