Hi Friends.

i am working on my internal work. i am having n dynamic rows, Each and every row contain total.

i want to sum all the rows total.

i have attached the screen shot for the reference

Attachments sum_textbox.jpg 8.25 KB

Use javascript or jQuery to add every rows totalrate value and show it in a total value. Providing some code may help to fix ur problem.


i have posted my script, i have written script for multiplication. but i need script for sum of total_rate in GrandTotal

<table width="100%" border="0" cellspacing="0" cellpadding="0">
                                        <th width="6%" height="30" align="center"><span class="tabletitle">S.No</span></th>
                                        <th width="44%"><span class="tabletitle">Description</span></th>
                                        <th width="13%"><span class="tabletitle">UOM</span></th>
                                        <th width="11%"><span class="tabletitle">Qty</span></th>
                                        <th height="30"><span class="tabletitle">Rate</span></th>
                                        <th width="16%"><span class="tabletitle">Total Rate</span></th>
					$create_po1 = $_POST['create_po'];
					$mat_po = $_POST['material_id'];
					$limit2 = count($create_po1);
						$create_po1[$k] = mysql_real_escape_string($create_po1[$k]);						
						$c_po = $create_po1[$k];
						$mat_po1 = $mat_po[$k];
					$qr = "select * from material_indent_req where id='$c_po' and status='Approved'";
					//echo $qr;
					$qres = mysql_query($qr,$conn);
					while($qrow = mysql_fetch_array($qres))
					$qindent_no = $qrow['indent_no'];
					$qmat = $qrow['material_subcat_code'];
					$qmatname = $qrow['material_subcat_name'];
					$qsite = "select *,count(po_no),sum(required_qty) from material_po where indent_no='$qrow[indent_no]' and material_id='$qmat'";
					//echo $qsite;
					$qrsite = mysql_query($qsite,$conn);
					$qmsite = mysql_fetch_array($qrsite);
					$req_ty = $qmsite['sum(required_qty)'];
					$site = $qrow['sitename'];
					$count_po = $qmsite['count(indent_no)'] + 1;
					$pending_qty = $qrow['required_qty'] - $req_ty;
				                    <tr class="light">
                                        <td height="30" align="center"><span class="logintitle"><?php echo $j;?></span></td>
                                        <td><span class="logintitle"><?php echo $qmatname;?></span></td>
                                        <td><span class="logintitle"><?php echo $qrow['unit'];?></span></td>
                                        <td><input name="required_qty[]" type="text" class="inputline" id="required_qty<?php echo $j;?>" value="<?php echo $pending_qty;?>" size="12" /></td>
                                        <td width="10%"><input name="rate[]" type="text" class="inputline" id="rate<?php echo $j; ?>" onchange="multiply(<?php echo $j; ?>)" size="12"/></td>
                                        <td><input name="total_rate[]" type="text" class="inputline" id="total_rate<?php echo $j; ?>" size="18" readonly="readonly"/></td>
                                      <?php $j++; } } ?>
                                      <tr class="dark">
                                        <td height="30" colspan="4">&nbsp;</td>
                                        <td><span class="tabletitle">Total </span></td>
                                        <td><input name="GrandTotal" type="text" class="inputline" id="GrandTotal" size="20" readonly="readonly"/></td>
                                      <tr class="light">
                                        <td height="30" colspan="4">&nbsp;</td>
                                        <td><span class="tabletitle">VAT</span></td>
                                      <tr class="dark">
                                        <td height="30" colspan="4">&nbsp;</td>
                                        <td><span class="tabletitle">Net Total </span></td>

At some point, unclear in your code, you are multiplying qty x rate for each item, so $item_total = qty x rate; although, I do not see this in your code here. anyway I am assuming this is happening in your while loop as you are doing each item. so prior to your while loop make a new variable $grand_total = 0;
inside your while loop after $item_total is calculated do this:

$grand_total += $item_total;  // <-- wherever $item_total comes from.
// when you want to display it, $grand_total should hold the values of all items.


Thanks for your reply.

i have done the multiplication through Java script the code is below

<script type=text/javascript>
function multiply(id){
var a;
var b;
var c;
a = document.getElementById("rate" + id).value;
b = document.getElementById("required_qty" + id).value;
c = a * b
document.getElementById("total_rate" + id).value = Math.round(c*100)/100;

function getSum(){
				var val=document.getElementById("total_rate" + id).value;
                var sum=0;
                for(var  j=0;j<val.id;j++){
                    sum +=val;

                alert("total is ="+sum);
               // str+="<span><input type='text' value="sum" /></span>";


and i am trying to find out sum through getsum function as above.

Help me

I want to add multiple dynamic textboxes on button click depends on my need and there is already one text box in which value=50
So my q. is the sum of values in dynamic textboxes should not be greater than 50 if the sum = 50 then textboxses should not be added dynamicaly on button click it must show an alert message for Sum cant be greater than 50

plz give me an ans....
or mail me on pavanmali.5679@gmail.com

start your own thread. Show any work you've done so far. Also describe what else you tried and what didn't work. This isn't a free code service, it's a help forum for helping you with YOUR code.

This question has already been answered. Start a new discussion instead.