Need to add MySQL field totals together

Discussion in 'MySQL' started by tyler_durden, Apr 27, 2011.

0
  1. #1
    Table ="term_count"
    Each row has 2 fields = "term" and "count"


    There are hundreds of rows, I only need the four with the "term" field equalling 503,507,623, and 634. The output should be the four "count" fields added together. I just want to display the total number, would this be better to do with PHP script or a MySQl statement, and how?
     
    tyler_durden, Apr 27, 2011 IP
  2. plog

    plog Peon

    Messages:
    298
    Likes Received:
    11
    Best Answers:
    1
    Trophy Points:
    0
    #2
    You need to use both PHP and MySQL. MySQL retreives the data from the database, PHP allows you to display it. Here is the SQL for the query to get that information:

    SELECT SUM(term_count.count) AS total FROM term_count WHERE term=503 OR term=507 OR term=623 or term=634;
     
    plog, Apr 27, 2011 IP
  3. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #3
    I would probably go with something like:

    SELECT SUM(`count`) AS total FROM term_count WHERE term IN (503,507,623,634);

    Make sure you reference the count column using backticks `count`. COUNT() is a mysql function so you need the backticks to tell the database that you want the column and not the function.
     
    jestep, Apr 28, 2011 IP