SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Addict
    Join Date
    Jul 2010
    Posts
    247
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Sum of table rows will appear in a textfield

    Good day!

    I have a problem in adding codes in my php codes, but i have the concept of codes that i want to add in my php codes, but I don't know if it is right. Kindly check my codes thank you.

    I attached my whole codes for better understanding

    and here is the codes I want to add:

    PHP Code:
    <?php
      
    if($_POST["clt_no"])
        {
        
    $query "SELECT * FROM clt_transact WHERE  clt_no = '" $_POST "'";
        
    $result_no mysql_query($query);
            if(
    $result_no)
                {
                if(
    mysql_num_rows($result_no) > )
                
    $operation2_input 0;
                
                
    $query "SELECT SUM(t.input_qty) AS operation_input FROM clt_traceability t, clt_transact p WHERE t.clt_transact_id = p.clt_transact_id AND t.operation_name 'Operation2' AND p.clt_no='" $_POST["clt_no"] . "'";
                
    $resultyield mysql_query($query);
                if(
    $resultyield)
                    {
                        if(
    mysql_num_rows($resultyield) > 0)$operation2_input =mysql_result($resultyield,0,"operation2_input");
                    }
                  
    $operation2_total $operation2_input;
                }
        }
    ?>
    I want to happen is all the input qty that the user insert in input qty textfield will sum and the result will appear in operation2_total in input_qty textfield.

    I don't know how thus the result should be appear automatically in the input qty of operation2_total and if my code is correct.

    Thank you
    Attached Files Attached Files
    Last edited by SpacePhoenix; Dec 15, 2010 at 00:53. Reason: placed php tags around the php code

  2. #2
    SitePoint Addict
    Join Date
    Jul 2010
    Posts
    247
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have 5 operation name: operation1,operation2,operation2_total,operation3,operation4,operation5. As you notice I have a operation2_total

    How can I add the input qty of operation2 and the result will be appear in input_qty of operation2_total.
    Attached Files Attached Files


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •