Results 1 to 2 of 2

Thread: MySQL Structure

  1. #1
    Join Date
    Jan 2006
    Posts
    1

    Unanswered: MySQL Structure

    I want to design a database that includes 2 fields that collect a dollar amount. Is it possible to have these two fields total themselves? I don't want both fields to total together, I want field 1 to total and field 2 to total seperate of each other.

  2. #2
    Join Date
    Dec 2005
    Posts
    3
    Do you want to keep running totals for each column? If so, just update that column to current_amount = current_amount + new_amount.

    Rich

Posting Permissions

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