[Johnson-php]

Hi there

I am making a points system on my site, like when someone post something on shoutbox the members get 1 point.
I tried this code

$result = mysql_query("SELECT * FROM members WHERE username='Johnson'");
$points = $result["points"];
$points += 20;
mysql_query("UPDATE members SET points = '$points' WHERE username='Johnson'");

Let me explain it again:
If the member X have 20 points and he post something on shoutbox he will have 40 points and if post again he will havbe 60...

I did a search on google and didn't find anything that could help me.

so any help here ?

Thanks!

[noorahmad]

if you want to give one point then add one with your $points Example $points++ or $points = $points + 1;and also you can add one point in your update query:
example: mysql_query("UPDATE members SET `points` = `points` +1")or die(mysql_error());
Hope it helps

[Johnson-php]

noorahmad, on 14 Nov, 2009 - 09:44 PM, said:

if you want to give one point then add one with your $points Example $points++ or $points = $points + 1;and also you can add one point in your update query:
example: mysql_query("UPDATE members SET `points` = `points` +1")or die(mysql_error());
Hope it helps

hey Thanks for the reply!

I tried the code above but it only stay on 1 if I update the page it just stay on 1

so the member will always have 1 point

I mean like this :

If member X have 1 point and he post something on shoutbox he will get 1 point and he will have 2 points

Hope it helps :-)

[masashiorika]

You'll probably want to change '$points' to just $points

[Johnson-php]

masashiorika, on 14 Nov, 2009 - 10:11 PM, said:

You'll probably want to change '$points' to just $points

I mean its like points system as I said above:

if Member X have 2 points and post something on shoutbox he will get more 2 points and he will have 4 points.

[noorahmad]

change this code:

$result = mysql_query("SELECT * FROM members WHERE username='Johnson'");
$points = $result["points"];
$points += 20;
mysql_query("UPDATE members SET points = '$points' WHERE username='Johnson'");

to this:

mysql_query("UPDATE `members` SET `points` = `points` + `points` WHERE username='Johnson'");

Edit: I change the code and it doubles the points

This post has been edited by noorahmad: 15 November 2009 - 12:15 AM

[Johnson-php]

noorahmad, on 14 Nov, 2009 - 11:11 PM, said:

change this code:

$result = mysql_query("SELECT * FROM members WHERE username='Johnson'");
$points = $result["points"];
$points += 20;
mysql_query("UPDATE members SET points = '$points' WHERE username='Johnson'");

to this:

mysql_query("UPDATE `members` SET `points` = `points` + `points` WHERE username='Johnson'");

Edit: I change the code and it doubles the points

WOW! You are the God!
Many thanks mate
I will thank you :-))))

[Johnson-php]

noorahmad, on 14 Nov, 2009 - 11:11 PM, said:

change this code:

$result = mysql_query("SELECT * FROM members WHERE username='Johnson'");
$points = $result["points"];
$points += 20;
mysql_query("UPDATE members SET points = '$points' WHERE username='Johnson'");

to this:

mysql_query("UPDATE `members` SET `points` = `points` + `points` WHERE username='Johnson'");

Edit: I change the code and it doubles the points

Thanks!
but the code you give to me duplicate the value is there any code to increase by 1,2,3,4,5,6,7,8 ? :-)

THANKS!

This post has been edited by Johnson-php: 15 November 2009 - 12:54 AM

[noorahmad]

Yes!, instate of points in mysql_query("UPDATE `members` SET `points` = `points` + `points` WHERE username='Johnson'"); use 1 (one) something like this
mysql_query("UPDATE `members` SET `points` = `points` + 1 WHERE username='Johnson'");

[Johnson-php]

noorahmad, on 15 Nov, 2009 - 12:10 AM, said:

Yes!, instate of points in mysql_query("UPDATE `members` SET `points` = `points` + `points` WHERE username='Johnson'"); use 1 (one) something like this
mysql_query("UPDATE `members` SET `points` = `points` + 1 WHERE username='Johnson'");

Thanks! finally I found the key to solve my problem

I'll thank you 1 more time

[noorahmad]

You are welcome