Closed Insert two values in 1 dropdown selection

[daredavil07]

Hello mga bossing, pano po ako makakakuha ng dalawang output sa isang dropdown selection para ma push sa dalawan db columns pag submit?

<select  name="code" id="drop" type="text">
            <option value="alpha">Alpha</option>
            <option value="tango">Tango</option>                 
            </select>

For example, pag na select si Alpha: alpha --> $code ; 0 --> $num
Tango: tango --> $code ; 1 --> $num

Salamat po ng marami!

 

[donteatmeat]

try this or like this?

<select>
  <optgroup label="Swedish Cars">
    <option value="volvo">Volvo</option>
    <option value="saab">Saab</option>
  </optgroup>
  <optgroup label="German Cars">
    <option value="mercedes">Mercedes</option>
    <option value="audi">Audi</option>
  </optgroup>
</select>

source: w3schools.

yung multi level drop down thru css lang ang alam ko at nakikita ko.

 

[daredavil07]

try this or like this?

<select>
  <optgroup label="Swedish Cars">
    <option value="volvo">Volvo</option>
    <option value="saab">Saab</option>
  </optgroup>
  <optgroup label="German Cars">
    <option value="mercedes">Mercedes</option>
    <option value="audi">Audi</option>
  </optgroup>
</select>

source: w3schools.

yung multi level drop down thru css lang ang alam ko at nakikita ko.

Di po sir. Bale po pag nag-select ng "Alpha" sa dropdown at submit. Sa dalawang column ng DB po sya mag e-insert ng values na 'alpha' sa column $code at '0' sa column $num in same row.

 

[LadyClare]

Set ka ng array with two values sa 0 at 1
Then foreach mo nlng then depende na sa trip mo if i echo or set value

 

[daredavil07]

Salamat po mga bossing! Nagawa kona po gamit ang jscript:

function configureDropDownLists(drop1,drop2) {
        var alpha= new Array('0');
        var tango= new Array('1');
            
        switch (drop1.value) {
            case 'Alpha':
                drop2.options.length = 0;
                for (i = 0; i < alpha.length; i++) {
                    createOption(drop2, alpha[i], alpha[i]);
                }
                break;
            case 'Tango':
                drop2.options.length = 0;
            for (i = 0; i < tango.length; i++) {
                createOption(drop2, tango[i], tango[i]);
                }
                break;
                     default:
                    drop2.options.length = 0;
                break;
        }

    }

    function createOption(drop1, text, value) {
        var opt = document.createElement('option');
        opt.value = value;
        opt.text = text;
        drop1.options.add(opt);
    }