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

Must-Know Topics of PHP
Can you guys list the must-know topics of PHP. I am still a learner and I am trying to cover most of

problem with script manager
Hi iam using Net.2005.I have created ajax enabledwebsite.i have master page in which i have script m

Trying to add functions to table
I have this list of characters and I'm trying to figure out what I have to do to put the results of

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

Posting to another Site?
I have software that people install.
When they install it, is there a way to make it post their d

Login Control?!
I have a Web Site that uses the login control also I have set the destinationurl to the page I want

word wrap in emails help needed
Hello, I understand how wordwrap works in php and have used it well before. However when I used wor

How to have a log of all the status a VIM document had been ?
Hi guys,

I’m using SAP Invoice Management plugin and the /OPT/VIM_ANALYTICS transa

Deleting a record php
Attempting to setup delete a record page. The below code I put together doesn't seem to work.

generating random codes
Hi guys n gals,

I have a requirement to generate 250,000 unique codes...

These codes a