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

Onclick problem in Firefox
Hi,
I am using a . It doesn't seem to

FFmpeg Images 2 Video conversion problem ??
I got folder full of images , number of images = 600 , I want to make a video which plays one image

Php - mysql store data and use it later?
Hi, i' making a login page at the moment, however my username + password is stored many different pl

PayPal Redirect Issue
When I have my paypal button set so that is redirects to http://empiremarketing.ca/order.php,it work

POST into Array problem
Hi Chaps,

I have a repeat region, displaying rows of data: jobid, fromtable, translatorcharge

Supress some serveroutput but not all
Hi,

I have a script I'm working on that uses plsql to create and RMAN script, this uses d

Show specific day of the week
I have been racking my brain trying to get this function to work properly and it is doing so for eve

XML Grouping
I'm using xml_parse_into_struct to get all my elements, but now I need to group them. For example, h

Local file browser with php
Halo..

So this is what i want to create. I have a folder that i share and it has many movies.

Problem with a select distinct
I have a problema with a select distinct, I have the next sql:

select distinct a,b,c,d fr