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

Certain files upload, while others do not
I want to read the data from an uploaded file. Not sure why, but it only uploads for certain files.

Navigation include for all site directories
Hi,

I need a navigation include that can deal with directories at different levels on a site.

Get relative path from absolute path
How would one go about getting the relative path to a file from its absolute path?

PHP Mysql Staff Induction System
Hi there, I'm pretty new to PHP and Mysql so could really do with being pointed in the right directi

Small problem with image resize script
Hi!

I am a little bit new to php and I have an issue installing an image resize script I down

Problem!
I have another problem, when i run this code i get this error "Parse error: syntax error, unexp

need good snippet manager
Hi. as i am coding and learning more, it is becoming difficult to manage code snippets. how you mana

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

Insert data in Mysql and move to another page
I'm stuck with this simple problem. I need to insert data in Mysql and then hit submit and move to a

DBCA Templates
Hi all,

I'm working on creating a template for DBCA, but can't find any documentation on the