Add 1 to a database

[webnoob]

I need to be able to add 1 to a databse when a user clicks on a link that takes them to an external site?

Thanks in advance

[vinyl-junkie]

Add 1 to what? A visitor counter that's stored in your database, or are you talking about something else? Is the link to the external site on your web page?

[cranial-bore]

If you want to increment the count the SQL query would look something like this:

 mysql_query("UPDATE table SET count=count+1 WHERE ID=$ID");