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

Simple PHP/Java Help..
Hi,
I'm trying to build a little program to do with calculating postage. Unfortunately i haven't

how to remove in php string display
My code is $message="We're looking at developing our website."; $body= "My mess

(sub)screen resize modification doesn't work after ECC 6 EhP 4 installation
Hello,

We have previously extended the size of the custom data tab on PO transaction ME23

What makes a script your own?
If someone finds a login script online, and changes some variable names around and some other minor

help countdown timers
hello every one,

I'd like to know how to insert many countdowns in the same page.
The dura

Sending CC Info by email
I am a little bit less knowledgable in the security area as most developers and I know I have a lot

mysql_query returning boolean instead of mysql ressource
Hi,

I seem to have a weird issue with the php command mysql_query. I pass 2 arguments the que

Do While statement
hi guys,

This may sound trivial but im new to php and as part of an assignmenti have to const

Registration
ok so i have a site where people can register and login which works now thanks to someone on here th

php code generators
All

Whilst enjoying learning a new language i have come accross a number of free code generat