Results 1 to 2 of 2

Thread: Displaying Column Total

  1. #1
    Join Date
    Feb 2009
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Default Displaying Column Total

    Hey DD world!

    Im trying to learn how to display the total (sum) of an int column. The real world scenario goes like this:

    There is a table that is used to log 'username' and 'points'. Records are added manually along with a date stamp whenever they earn points based on the organization's rules. The structure may look like

    recordID (prim)

    userID (indx)

    date (date/timestamp)

    points (int)

    I want to display on the homepage of the site that uses this to show some retrieved data. More specifically the User and Total Points.

    Is there any PHP or script to display the Total Points based on 'userID' or User?

    Or do I have to make a totally new kind of table to calculate and record sums?

    I'm only interested on displaying total points, not neccisarily recording them.


    Thanks for any help or direction I can get on this!!! Have a great day!

  2. #2
    Join Date
    Jun 2005
    Location
    英国
    Posts
    11,876
    Thanks
    1
    Thanked 180 Times in 172 Posts
    Blog Entries
    2

    Default

    Code:
    SELECT SUM(points) AS total_points FROM your_table WHERE user_id = '$user_id'
    Twey | I understand English | 日本語が分かります | mi jimpe fi le jbobau | mi esperanton komprenas | je comprends franšais | entiendo espa˝ol | t˘i Ýt hiểu tiếng Việt | ich verstehe ein bisschen Deutsch | beware XHTML | common coding mistakes | tutorials | various stuff | argh PHP!

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
  •