Professional Web Applications Themes

Adding points to a database ( adding / subtrating numeric values) - PHP Development

HI all, I have build a user database that comes with user points for browsing private section of my site. I would like to know what is the best way to add points and subtract points for a specific user. can i just do something like UPDATE mytable SET userpts = +10 where username = '$username' ? or UPDATE mytable SET userpts = -5 where username = '$username' ? being a newbie , i am not familiar with mathematical functions and Mysql. Can anyone advise me on this subject or tell me if my example is ok. Thank you very ...

  1. #1

    Default Adding points to a database ( adding / subtrating numeric values)

    HI all,

    I have build a user database that comes with user points for browsing
    private section of my site.

    I would like to know what is the best way to add points and subtract points
    for a specific user.

    can i just do something like

    UPDATE mytable SET userpts = +10 where username = '$username' ?

    or

    UPDATE mytable SET userpts = -5 where username = '$username' ?

    being a newbie , i am not familiar with mathematical functions and Mysql.

    Can anyone advise me on this subject or tell me if my example is ok.

    Thank you very much.



    tsagoii Guest

  2. #2

    Default Re: Adding points to a database ( adding / subtrating numeric values)

    Hi,

    I dont't really know if I'm getting you right, but this has to a valid
    SQL-Statement for sure:

    UPDATE mytable SET userpts = userpts + 10 where username = '$username';

    HTH
    Alex

    "tsagoii" <lovelove.com> schrieb im Newsbeitrag
    news:NsNab.3953$mv6.669294news20.bellglobal.com.. .
    > HI all,
    >
    > I have build a user database that comes with user points for browsing
    > private section of my site.
    >
    > I would like to know what is the best way to add points and subtract
    points
    > for a specific user.
    >
    > can i just do something like
    >
    > UPDATE mytable SET userpts = +10 where username = '$username' ?
    >
    > or
    >
    > UPDATE mytable SET userpts = -5 where username = '$username' ?
    >
    > being a newbie , i am not familiar with mathematical functions and Mysql.
    >
    > Can anyone advise me on this subject or tell me if my example is ok.
    >
    > Thank you very much.
    >
    >
    >

    Alexander Schmidt Guest

Similar Threads

  1. adding values
    By sidvic in forum Coldfusion Flash Integration
    Replies: 0
    Last Post: March 13th, 10:34 AM
  2. Adding values from a database
    By neilorourker in forum Coldfusion - Getting Started
    Replies: 1
    Last Post: August 7th, 05:06 PM
  3. Adding points to a path
    By wrand@mac.com in forum Macromedia Freehand
    Replies: 1
    Last Post: September 15th, 10:53 PM
  4. Adding Points to a Circle
    By davidl000 webforumsuser@macromedia.com in forum Macromedia Freehand
    Replies: 6
    Last Post: August 29th, 06:32 PM
  5. Adding custom values and database values to DropDwonList
    By William F. Robertson, Jr. in forum ASP.NET General
    Replies: 0
    Last Post: July 1st, 06:32 PM

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
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139