Professional Web Applications Themes

Calculating - PHP Development

Hello everyone... I am going to make a script where I can add and subtract an amount from the database... Lets say 'james' have '2000'. And I want to add '500'... What is the code to add and subtract 2 variables? I also want to have 2 radio buttons, Add or Subtract.. Then: if(add){ $new_amount ($amount + $_POST['new_amount']) } if(subtract){ $new_amount ($amount - $_POST['new_amount']) } $sql = mysql_query("INSERT INTO amount VALUE $new_amount") or die (mysql_error()); I know this wount work, but I just wanted you to know almost how I mean.. =P Can someone please help me? Sincerely, Andreas Saarva....

  1. #1

    Default Calculating

    Hello everyone...

    I am going to make a script where I can add and subtract an amount from the
    database... Lets say 'james' have '2000'. And I want to add '500'...

    What is the code to add and subtract 2 variables?

    I also want to have 2 radio buttons, Add or Subtract.. Then:

    if(add){
    $new_amount ($amount + $_POST['new_amount'])
    }
    if(subtract){
    $new_amount ($amount - $_POST['new_amount'])
    }
    $sql = mysql_query("INSERT INTO amount VALUE $new_amount") or die
    (mysql_error());


    I know this wount work, but I just wanted you to know almost how I mean.. =P

    Can someone please help me?

    Sincerely,
    Andreas Saarva.


    Andreas Saarva Guest

  2. #2

    Default Re: Calculating

    *** Andreas Saarva wrote/escribió (Thu, 26 Feb 2004 13:15:54 +0100):
    > I am going to make a script where I can add and subtract an amount from the
    > database... Lets say 'james' have '2000'. And I want to add '500'...
    > INSERT INTO amount VALUE $new_amount") or die
    > (mysql_error());
    Do you mean "UPDATE cash SET amount=amount+2 WHERE user='james'" ?

    --
    --
    -- Álvaro G. Vicario - Burgos, Spain
    --
    Alvaro G Vicario Guest

  3. #3

    Default Re: Calculating

    Nah... a script that calculates. =S

    "Alvaro G Vicario" <alvaro_QUITAR_REMOVEtelecomputeronline.com> skrev i
    meddelandet news:esovvpksajb4$.zqhmsshfczz9.dlg40tude.net...
    > *** Andreas Saarva wrote/escribió (Thu, 26 Feb 2004 13:15:54 +0100):
    > > I am going to make a script where I can add and subtract an amount from
    the
    > > database... Lets say 'james' have '2000'. And I want to add '500'...
    >
    > > INSERT INTO amount VALUE $new_amount") or die
    > > (mysql_error());
    >
    > Do you mean "UPDATE cash SET amount=amount+2 WHERE user='james'" ?
    >
    > --
    > --
    > -- Álvaro G. Vicario - Burgos, Spain
    > --

    Andreas Saarva Guest

Similar Threads

  1. calculating in tables
    By fisherman in forum Macromedia Exchange Dreamweaver Extensions
    Replies: 1
    Last Post: October 23rd, 09:05 PM
  2. Calculating age
    By Tom Thackrey in forum PHP Development
    Replies: 9
    Last Post: June 9th, 08:49 PM
  3. calculating time
    By wally_errrr in forum Macromedia Director 3D
    Replies: 3
    Last Post: May 8th, 09:43 AM
  4. Calculating Fields
    By will_garcia@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 1
    Last Post: April 27th, 08:17 PM
  5. Calculating field in ASP
    By in forum ASP Database
    Replies: 13
    Last Post: January 10th, 01:37 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139