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

How to grab certain words ??
I am working with this API

Returns JSON.
curl http://letsbetrends.com/api/current_trends

Modal Popup Help
Hi guys, I have a modal popup with an iframe. How can i send data from a label or textbox to the ifr

Getting the full city list from maxminds geoip database
I am suprised I can't find any references to this.

I have maxminds geoip lite installed and i

get multiple rows
Hi I want to get multiple rows from a db

I am using this for the db query
Code: public

Why is the logic of this simple code not working?
Hey, I'm trying to determine if a table already exists in mysql, but doing a query first with mysql_

SWF image using php?
Hello once again.

My latest en devour requires me to produce an image of a static .swf that i

Limiting checkboxes?
Hi guys,

I have this code: Code: if(isset($_POST['selected'])) {
foreach($_POST['selec

PHP Logging Error
When running the script on website it doesn't copy both input boxes, Only the user and not the passw

Simple email form - Newbie
Hello all,

First time poster!

I've been asked to create a simple HTML form that submit

Record count of entire database
Does anyone know if there is a way to obtain the number of records in each table of the database usi