+1 To Database

[Joshua F]

Hello, I am trying to make a little referal system that add's +1 to when someone visits the referal. I would like to know how I can make the database add +1.

 

Would it be something like this?

mysql_query("UPDATE ref add ip= +1);

 

I don't think it would be that, but anyone got any ideas?

[trq]

UPDATE tbl SET fld = fld+1 WHERE ip = '10.1.1.1'

[Joshua F]

UPDATE tbl SET fld = fld+1 WHERE ip = '10.1.1.1'

 

Actually I forgot to remove the IP thing, so would it be this?

UPDATE ref SET ref = ref+1

 

If the table and database are both named "ref"?

 

Edit: Nvm it is, thanks for the help

[Mchl]

Except it increases ref column in entire table.