Results 1 to 3 of 3

Thread: total points

  1. 02-27-2008, 01:22 AM #1
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421

    total points

    in mysql we have survey table, column 5 to 27 is point for different question , how can i got the total for one user have id
    thank you
    ________
    MERCURY MONARCH
    Last edited by sql; 03-06-2011 at 02:03 AM.
    Reply With Quote Reply With Quote
  2. 03-11-2008, 09:19 PM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    selec column5+6+7+8.....column27 from table where id =1
    My Site:http://www.mssqlengineering.com
    My Book:http://www.wiley.com/WileyCDA/WileyT...470477288.html
    Reply With Quote Reply With Quote
  3. 03-13-2008, 08:22 PM #3
    sql
    sql is offline Registered User
    Join Date
    Jul 2003
    Posts
    421
    Quote Originally Posted by MAK
    selec column5+6+7+8.....column27 from table where id =1
    thank you Mak, I add that in session before get into db, but you point out another way, your answer always useful
    ________
    Honda l700
    Last edited by sql; 03-06-2011 at 02:04 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules