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

Amatuer requiring assistance
Beginner and amateur in need of assistance

My Site - (Spare Parts for Domestic Appliances)

Comparing Values
Hi
I'm reading data from a database and this seems to work OK.

Each system has an associat

gmdate() - want 1 hr before time
Hi,
I am using php gmdate().
Now I am entering all dates in my dbase using gmdate("Y-m-d

Protecting forms
Alright, I want to protect some forms of mine from SQL Injections, because I had someone earlier spa

Querying info from one table based on info in another
Hi, I am currently trying to make a part for my user driven website where one user can subscribe to

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

socket makes browser hang...
I have a socket server, and I am having a problem at the moment...

A browser sends a http hea

cstdatomic (c++0x std::atomic) / g++ 4.4
Hello,

I'm trying to use cstdatomic (std::atomic in the upcoming c++0x standard) in g++

include
Hi I have this way of licensing my PHP application, and I want to know if you guys can answer some q

Need PHP help... have all the elements... just need help putting them together :
Hey Guys,

I was wondering if someone could help me. I am doing a website for a client which