Results 1 to 1 of 1
  1. #1
    Join Date
    Oct 2009
    Posts
    6

    Unanswered: need help with a shop

    I have no idea how to do addition or subtraction in a mysql database using php. Basically I am looking to have a text box that someone would input the amount of an item they want to purchase, and then it would multiply the amount they want by the cost, and it would do 2 things:

    1. add the amount of bait to the persons inventory
    2. subtract the sum of the numbers multiplied from their money

    would anyone be able to assist me with this.

    The variables I am using in this document are:

    bait_amount
    bait_type
    money

    I figured out how to get it to work with a set amount like below:

    PHP Code:
    $sql "update birds_sighting set bait_amount = bait_amount + 1 where user = '1'";
           
    $result mysql_query ($sql);

    $sql "update birds_sighting set money = money - 200 where user = '1'";
           
    $result mysql_query ($sql); 
    I just need to figure out how to make it have text boxes that will multiply the 2 values together

    also, i am having issues when selling, the items will still sell even when the value goes to a negative number. would anyone be able to help me figure out how to make it stop before it reaches 0 so i do not get a negative number?
    Last edited by omegaxero; 11-18-09 at 23:00. Reason: found 1 solution, need the other still

Posting Permissions

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