title: Update Price based on dropdown list selection
body: <p>I have a dropdown list populated by mysql working perfectly, I also have it displaying the price set by mysql, so far i'm happy.</p>
  
  <p>What the issue is as it's a multiple dropdown list, it will only display what is chosen first, if I pick 2 or more selections, only the first price is shown.</p>
  
  <p>My second issue is I want the prices to add up i.e. 1st Selection's price is £1.99, 2nd Selection's price is £2.99 so the total should be £4.98</p>
  
  <p>Finally once i have all this working, I want to continue this onto the 2nd / 3rd / 4th dropdown boxes so that all the boxes add up giving me a combined total.</p>
  
  <p><strong>Here's my html code to show you what i'm using:</strong></p>
  
  <pre><code>&lt;form method="post" action="" name="form1"&gt;
    &lt;? 
    include 'classes.php';
    $query="SELECT * FROM Sex_Table";
    $result=mysql_query($query);
    ?&gt;
    &lt;select data-placeholder="Your Favorite Football Team"  class="chzn-select" multiple tabindex="6" id="Sexdiv" name="Sexdiv" style="width: 300px;" onChange="getClothing(this.value),changePrice()"&gt;
    &lt;option&gt;Select Colour Type&lt;/option&gt;
    &lt;? while($row=mysql_fetch_array($result)) { ?&gt;
    &lt;option value=&lt;?=$row['ID']?&gt; sex_price="&lt;?=$row['Price']?&gt;"&gt;&lt;?=$row['Sex_Name']?&gt;&amp;nbsp;(£&lt;?=$row['Price']?&gt;)&lt;/option&gt;
    &lt;? } ?&gt;
    &lt;/select&gt;&lt;br /&gt;&lt;br /&gt;
    &lt;p id="Clothingdiv"&gt;
    &lt;select style="width: 300px;" name="Clothing" disabled='disabled'&gt;
    &lt;option&gt;Select Sex First&lt;/option&gt;
    &lt;/select&gt;
    &lt;/p&gt;&lt;br /&gt;
    &lt;script type="text/javascript"&gt; $(".chzn-select").chosen(); $(".chzn-select-deselect").chosen({allow_single_deselect:true}); &lt;/script&gt;
    &lt;/form&gt;
  </code></pre>
  
  <p><strong>and here's my js:</strong></p>
  
  <pre><code>function changePrice() {
   var sex_price = $("option:selected").attr("sex_price");
   $("#price_div").html("Price = £" + sex_price);
  }
  </code></pre>
  
  <p>Thanks</p>