Adding to an Int row in db

Posted on 16th Feb 2014 07:03 pm by admin

Hi, i have a database which houses all of the users of my site. One of the columns is for points which is default 0.
What I would like to do is add 1 to this number each time they upload an image. What code would i use for this? I have an idea but i dont think it would work. My idea is something like:

$add= +1

$sql ("update users set points=$add")

Something like that?

Your Answer:

Login to answer

Other forums

need help to creat database
Hello Team, please guys i am stuck from three days with paypal issue for IPN but no luck yet now i w

reating a background image
I am building a site in drupal and have a php form in it, due to certain annoyances with module buil

Function to extract email attachments using PHP IMAP
function extract_attachments($connection, $message_number) {

$attachments = array();

dropdown box help - open php files to textarea
Hi, I am using tinymce to edit content located in several php files. The code I attached works but i

Help with ORDER BY
Hello. I would like to order by ascending States, then Cities, then Gyms in the following code, but

chat
hello i'm amir i need a chat source code in asp.net 2.0 without Ajax. anybody can help me?

DB2 for z/OS, LUW, iSeries
Hello, In this forum a lot of threads related to other members of the DB2 family than DB2 for z/OS

batch file not building to webapps folder
Hello. I just started running Vista :P and can't seem to get my projects deployed. I found out how

SCRIPT ERROR
Here is the CONTACT FORM I made for our website:

<form id="form1" name="

Need Help with a query
Hello,
For some reason I am just not getting the right answer when I do this query and not quite