Dropdown from database

[eluser]Kentus[/eluser]
Hi everyone, i need some help in this problem:
i have a dropdown select with 7 values.
i have another dropdown where i suppose to show in each option a value from database where name="precedent dropdown value selected".

i have this code:

Code:

<div id="reg_text">
            &lt;?php
            $name='race_dropdown';
                $js = 'id="race_dropdown" onChange="setImage(this,gender_dropdown)"';
            $data=array(
            'id'=>'race_dropdown');
            $options = array(
                  'suising'  => 'Suising People',
                  'simuud'    => 'Si-mu-ud People',
                  'ranus'   => 'Ranus People',
                  'neberu' => 'Neberu People',
                   'kayamanu'   => 'Kayamanu People',
                  'naheed' => 'Naheed People',
                  'ard'=>'Ard People'
                                  );

echo form_dropdown('race', $options, 'suising',$js);?&gt;
        </div>&lt;!--reg_text--&gt;
    </div>&lt;!--username_register1--&gt;
     <div id="username_register2">
        <div id="reg_label">
            Weapon:
        </div>&lt;!--reg_label--&gt;
        <div id="reg_text">
        
        &lt;?php
        $this->db->select('arm_one, arm_two, arm_three');
        $this->db->where('name',race_dropdown);
        $q=$this->db->get('race');
        var_dump($this->input->post('pageViewerID'));
            $name='weapon_dropdown';
            $options = array(
                  'sp1'  => $q[arm_one],
                  'sp2'    => $q[arm_two],
                  'sp3'   => $q[arm_three]                
                                  );


echo form_dropdown('weapon', $options, 'sp1','id="'. $name .'"');?&gt;
        </div>&lt;!--reg_text_spec--&gt;

Thanks for future advices.

[eluser]Wondering Coder[/eluser]
in my controller

Code:

$data['elem'] = $this->dataset_db->getElementary();

in my view

Code:

<select name="elem" class="searchIndustry">
                        <option value=""></option>
                        &lt;?php
                            foreach($elem as $item)
                            {
                               echo "<option value='".$item->elem_id.">".$item->elem_name."</option>";
                            }
                        ?&gt;
                    </select>&lt;?php echo form_error('elem'); ?&gt;<br />

[eluser]Kentus[/eluser]
My db structure: name, arm_one,arm_two,arm_three,power.
My first row: Mario, spear, arc, sword,20
Second row: John, knife, double sword, double axes, 30

My view: a select where you can choose between Mario and John.
another select where i must show arm_one, arm_two, arm_three contents for Mario if previously select is on Mario (that means: option one: spear, option two: arc, option three: sword) or if John is selected (option one: knife, option two: double sword, option three: double axes).

Wondering Coder thanks for trying helping me.

[eluser]theprodigy[/eluser]
Basically, what you want to do is set a onchange attribute on the first select box (or set a javascript listener), and have it do an ajax call to get the options for the next select drop down.

[eluser]Kentus[/eluser]
i found a method but isn't very good i think: i set a onchange attribute but i use this code in [removed]

Code:

var abc="http://89.41.129.47/earthwar"
var imgsuisingmale = new Image().src = abc+"/images/heroes/suising/1.jpg"
var imgsuisingfemale = new Image().src = abc+"/images/heroes/suising/2.jpg"
var imgranusmale = new Image().src = abc+"/images/heroes/ranus/1.jpg"
var imgranusfemale = new Image().src = abc+"/images/heroes/ranus/2.jpg"
var imgsimuudmale = new Image().src = abc+"/images/heroes/si-mu-ud/1.jpg"
var imgsimuudfemale = new Image().src = abc+"/images/heroes/si-mu-ud/2.jpg"
var imgneberumale = new Image().src = abc+"/images/heroes/neberu/1.jpg"
var imgneberufemale = new Image().src = abc+"/images/heroes/neberu/2.jpg"
var imgkayamanumale = new Image().src = abc+"/images/heroes/kayamanu/1.jpg"
var imgkayamanufemale = new Image().src = abc+"/images/heroes/kayamanu/2.jpg"
var imgnaheedmale = new Image().src = abc+"/images/heroes/naheed/1.jpg"
var imgnaheedfemale = new Image().src = abc+"/images/heroes/naheed/2.jpg"
var imgardmale = new Image().src = abc+"/images/heroes/ard/1.jpg"
var imgardfemale = new Image().src = abc+"/images/heroes/ard/2.jpg"
var wpnard=new Array();
    wpnard[0]="Hammer";
    wpnard[1]="Spear";
    wpnard[2]="Chakrum";
var wpnranus=new Array();
    wpnranus[0]="Khopesh";
    wpnranus[1]="Mace";
    wpnranus[2]="Arch";
var wpnsuising=new Array();
    wpnsuising[0]="Flash Knife";
    wpnsuising[1]="Light sword";
    wpnsuising[2]="Flashshot";
var wpnkayamanu=new Array();
    wpnkayamanu[0]="Double Axe";
    wpnkayamanu[1]="Crescent Axe";
    wpnkayamanu[2]="Sling";
var wpnnaheed=new Array();
    wpnnaheed[0]="Single Ball Flail";
    wpnnaheed[1]="Halberd";
    wpnnaheed[2]="Bow";
var wpnneberu=new Array();
    wpnneberu[0]="Tomahawk";
    wpnneberu[1]="Sword";
    wpnneberu[2]="Crossbow";
var wpnsimuud=new Array();
    wpnsimuud[0]="Mek-leKH";
    wpnsimuud[1]="Scepter";
    wpnsimuud[2]="Blow Gun";
function setImage(imageSelect,genderSelect,weaponSelect) {
    
theImageIndex = imageSelect.options[imageSelect.selectedIndex].value;
theGenderIndex=genderSelect.options[genderSelect.selectedIndex].value;
if (document.images)
     document.images[0].src = eval("img" + theImageIndex+theGenderIndex);
var path=eval("wpn" + theImageIndex)
weaponSelect.options.length=0
     weaponSelect.options[0] = new Option(path[0],"sp1" , true)
     weaponSelect.options[1] = new Option(path[1], "sp2" , true)
     weaponSelect.options[2] = new Option(path[2],"sp3" , true)
  }

i don't use ajax until now. i search on google but i have some questions: i need asp server?

[eluser]theprodigy[/eluser]

i don’t use ajax until now. i search on google but i have some questions: i need asp server?

No, you don't need an ASP server. Ajax is nothing more than javascript that makes a call to your server (either post or get), and can retrieve content based on the response of that call. It does it without doing a page refresh.

There are many prebuilt ajax objects out there that you can use (most common is part of jQuery), but I would strongly suggest learning about it before using it. One quick google search for "ajax tutorial php", brought up several sites, including this one from tizag

To use ajax with jQuery, their docs are http://api.jquery.com/jQuery.ajax/