How can I resolve the issue depicted in the second picture? I need the value of 3 only in the USD column, with all others having a value of zero.
<div class="span3">
<ul class="nav nav-tabs nav-stacked" >
<?php
foreach ( $submenu as $sm ) {
echo '<li><a href="'.$base_url.$sm['link'].'">'.$sm['title'].'</a></li>';
}
?>
</ul>
</div>
<div id="myModal" class="modal hide fade" tabindex="-1" role="dialog" aria-labelledby="myModalLabel" aria-hidden="true">
<div class="modal-header">
<button type="button" class="close" data-dismiss="modal" aria-hidden="true">×</button>
<h3 id="myModalLabel">Add New Daily Price Index</h3>
</div>
<div class="modal-body">
<form id="myForm" method="post">
<div class="span2">Index</div>
<input type="text" name="indexval" id="indexval"/>
<!--input type="hidden" value="hello" id="myField"-->
<!--button id="myFormSubmit" type="submit">Submit</button-->
</form>
</div>
<div class="modal-footer">
<button class="btn btn-primary" id="myFormSubmit" >Save</button>
<button class="btn" data-dismiss="modal" aria-hidden="true">Close</button>
</div>
...
First Picture:
Second Picture:
Query:
select type,indexval,delivery_date,priceval from price_indices
where delivery_date between '$sdate' and '$edate' and `type`='$type'
order by delivery_date