Points

I need to add a certain number of points when someone posts a status, and in my post.php, I have

mysql_query("UPDATE user SET points = '+2'
WHERE username = '$_SESSION[username]'");

It just sets the points to 2. I need help with adding 2 to the points. Thanks.

Che la stimo, che la stimo!

That's because you're setting the points equal to positive two. To add two onto the current value, try this:

<?php

$sql=mysql_fetch_array(mysql_query("SELECT * FROM user WHERE username='$_SESSION[username]'"));

$pts=$sql[points];

mysql_query("UPDATE user SET points='$pts+2'");
?>

That will get the job done.

It's my job to help the next generation, and set a good example for them. And for that I'll gladly lay down my life.

That doesn't do anything. :/

Che la stimo, che la stimo!

Type "or die(mysql_error());" after the query, or else errors will go unnoticed.

Trust me, I am The Doctor.

There were errors, and I fixed them, but now the code does nothing.

Che la stimo, che la stimo!

Go to google type in Mysql updated

it show you how to make points.

A true developer