Puling values from the populated dropdown list (PHP, ORACLE)

[chrishutagalung]

Hi folks, 

 

I am having problem with my project. I need to show the corresponding values from the populated drop down list. so in my table i have this. I need to show the quantity from the head_mark i chose from the populated drop down list. Please help me

<?php
    $paint_parse = oci_parse($conn, 'SELECT HEAD_MARK FROM PAINTING 	ORDER BY REV_DATE');
    oci_define_by_name($paint_parse, 'HEAD_MARK', $head_mark);
    oci_execute($paint_parse, OCI_DEFAULT);
?>

<section>
                                <div class="row">
                                    <div class="col4 first">
                                        <label for="headmark" class="lbl-text tleft">HEADMARK :</label>
                                    </div><!-- end .col4 section -->
                                    <div class="col8 last">
                                        <label for="headmark" class="lbl-ui select">
                                          <select id="headmark" name="headmark" onChange="">
                                                <?php while (oci_fetch($paint_parse)){?>
                                                <option value="headmark_sel" id="headmark"> <?php echo "$head_mark"; ?></option> <?php } ?>
                                          </select>
                                        </label>     
                                    </div>	
                                </div>                        
                           </section>                                                  
                           <section>
                                <div class="row">
                                    <div class="col4 first">
                                        <label for="lnames" class="lbl-text tleft">Total Quantity:</label>
                                    </div><!-- end .col4 section -->
                                    <div class="col8 last">
                                        <label class="lbl-ui">
                                            <!-- Show Corresponding head mark quantity in this field -->
                                            <h1><?php $qty_parse ?></h1>
                                        </label>
                                    </div><!-- end .col8 section -->	
                                </div><!-- end .row section-->                            
                           </section>