PHP - I Need A Grand Total Of "$total = Odbc_result($result, "total");"

  Basically I want to add up multiple tables and display a grand total on my page when the radio button is pressed. The radio button has values that connect to my database and the values link to and ID with a price. How can I use this code in order to work out a grand total? Many thanks. I have searched everywhere but found nothing.

Hello all, thanks for everything you do!

I used a php from generator to make the form seen on this page:
http://www.firstpresgreenville.org/forms/retirementform/retirementform-alt.html

I need to be able to click on the check boxes and get a dollar amount total in the total field....So if you checked "single", the total field would read $40, and if you checked on "couple", the field would read $50...simple as that...

Is there anyway to make that happen? 

This is the code I am working with now....

<?php

# This block must be placed at the very top of page.
# --------------------------------------------------
require_once( dirname(__FILE__).'/form.lib.php' );
phpfmg_display_form();
# --------------------------------------------------



function phpfmg_form( $sErr = false ){
        $style=" class='form_text' ";

?>

<form name="frmFormMail" action='' method='post' enctype='multipart/form-data' onsubmit='return fmgHandler.onsubmit();'>
<input type='hidden' name='formmail_submit' value='Y'>
<div id='err_required' class="form_error" style='display:none;'>
    <label class='form_error_title'>Please check the required fields</label>
</div>
           
           
<ol class='phpfmg_form' >

<li class='field_block' id='field_0_div'><div class='col_label'>
    <label class='form_field'>Full Name(s)</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_0"  id="field_0" value="<?php  phpfmg_hsc("field_0"); ?>" class='text_box'>
    <div id='field_0_tip' class='instruction'></div>
    </div>
</li>

<li class='field_block' id='field_1_div'><div class='col_label'>
    <label class='form_field'>Street Address</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_1"  id="field_1" value="<?php  phpfmg_hsc("field_1"); ?>" class='text_box'>
    <div id='field_1_tip' class='instruction'></div>
    </div>
</li>

<li class='field_block' id='field_2_div'><div class='col_label'>
    <label class='form_field'>City</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_2"  id="field_2" value="<?php  phpfmg_hsc("field_2"); ?>" class='text_box'>
    <div id='field_2_tip' class='instruction'></div>
    </div>
</li>

<li class='field_block' id='field_3_div'><div class='col_label'>
    <label class='form_field'>State</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_3"  id="field_3" value="<?php  phpfmg_hsc("field_3"); ?>" class='text_box'>
    <div id='field_3_tip' class='instruction'></div>
    </div>
</li>

<li class='field_block' id='field_4_div'><div class='col_label'>
    <label class='form_field'>Zip Code</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_4"  id="field_4" value="<?php  phpfmg_hsc("field_4"); ?>" class='text_box'>
    <div id='field_4_tip' class='instruction'></div>
    </div>
</li>

<li class='field_block' id='field_5_div'><div class='col_label'>
    <label class='form_field'>Phone</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_5"  id="field_5" value="<?php  phpfmg_hsc("field_5"); ?>" class='text_box'>
    <div id='field_5_tip' class='instruction'>(###) ###-####</div>
    </div>
</li>

<li class='field_block' id='field_6_div'><div class='col_label'>
    <label class='form_field'>Email</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_6"  id="field_6" value="<?php  phpfmg_hsc("field_6"); ?>" class='text_box'>
    <div id='field_6_tip' class='instruction'></div>
    </div>
</li>

<li class='field_block' id='field_7_div'><div class='col_label'>
    <label class='form_field'>Number of Attendees</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_7"  id="field_7" value="<?php  phpfmg_hsc("field_7"); ?>" class='text_box'>
    <div id='field_7_tip' class='instruction'></div>
    </div>
</li>

<li class='field_block' id='field_8_div'><div class='col_label'>
    <label class='form_field'>Single or Couple?</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <?php phpfmg_checkboxes( 'field_8', "Single|Couple" );?>
    <div id='field_8_tip' class='instruction'></div>
    </div>
</li>

<li class='field_block' id='field_9_div'><div class='col_label'>
    <label class='form_field'>Amount Due</label> <label class='form_required' >*</label> </div>
    <div class='col_field'>
    <input type="text" name="field_9"  id="field_9" value="<?php  phpfmg_hsc("field_9"); ?>" class='text_box'>
    <div id='field_9_tip' class='instruction'>$40/ single or $50/couple (Includes one book and lunch)</div>
    </div>
</li>

<li class='field_block' id='field_10_div'><div class='col_label'>
    <label class='form_field'>Additional Comments</label> <label class='form_required' >&nbsp;</label> </div>
    <div class='col_field'>
    <textarea name="field_10" id="field_10" rows=4 cols=25 class='text_area'><?php  phpfmg_hsc("field_10"); ?></textarea>

    <div id='field_10_tip' class='instruction'></div>
    </div>
</li>
<?php phpfmg_dependent_dropdown( 'field_11' );?>

            <li>
            <div class='col_label'>&nbsp;</div>
            <div class='form_submit_block col_field'>
   
                <input type='submit' value='Submit' class='form_button'>
                <span id='phpfmg_processing' style='display:none;'>
                    <img id='phpfmg_processing_gif' src='<?php echo PHPFMG_ADMIN_URL . '?mod=image&amp;func=processing' ;?>' border=0 alt='Processing...'> <label id='phpfmg_processing_dots'></label>
                </span>
            </div>
            </li>
           
</ol>
   
</form>

<?php
           
    phpfmg_javascript($sErr);

}
# end of form

function phpfmg_form_css(){
?>

Thanks so much!

<html>
    <head>
        <title>Sum Html Textbox Values using jQuery/JavaScript</title>
<script src="http://ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js"></script>
<script>
$(function() {
    $(document).on('blur keyup', '.add, .sub', function(e) {
        var sum = 0;
        $('.add, .sub').each(function(i) {
            if (!isNaN(this.value) && this.value.length != 0) {
                if ($(this).hasClass('add')) {
                    sum += parseFloat(this.value);
                }
                else {
                    sum -= parseFloat(this.value);
                }
            }
        });
        $('#total').text(sum.toFixed(2));
    })
})
</script>
    </head>
    <body>
<form method="post" action="calc.php">	
	Addition:
	<br/>
	Field 1: <input type="text" class="add" name="1" value="7500"/><br/>
	Field 2: <input type="text" class="add" name="2" value=""/><br/>
	Field 3: <input type="text" class="add" name="3" value=""/><br/>
	Field 4: <input type="text" class="add" name="4" value=""/><br/><br/>
	Total Addition: 
	<br/><br/>
	Substraction:
	<br/>
	Field 1: <input type="text" class="sub" name="5" value=""/><br/>
	Field 2: <input type="text" class="sub" name="6" value=""/><br/>
	Field 3: <input type="text" class="sub" name="7" value=""/><br/>
	Field 4: <input type="text" class="sub" name="8" value=""/><br/><br/>
	Total Substraction: 
	<br/><br/>
	Grand Total: <div id="total"></div>
	<input type="submit" value="submit" />
</form>
</body>
</html>

I get all the results displayed but how can I echo the total value for for all rows found for under column 'duration' which only contains numbers (seconds).   $query = "SELECT * FROM asterisk_cdr WHERE calldate LIKE '%$calldate%' AND channel LIKE '%$channel%' AND duration";

$result = mysqli_query($dbcon, $query) or die('Error getting data');
$num_rows = mysqli_num_rows($result);

hi all I have this can someone help me I'm trying to get a total cost


<?php
//inventory report printable total value in stock
$connect = mysql_connect('*******') or die (mysql_error());
mysql_select_db('fminventory') or die (mysql_error());

$query = mysql_query("SELECT SUM(cost) FROM cars");
$query2 = mysql_fetch_array($query);

echo $query2;

?>