adding to a database

[martinb7]

i hav an affiliates system. Website | traffic from us | 2us

i was wondering how do you make it plus 1 to the traffic from us column in the database if someone clicks on the link??

 

[sleipnir214]

Not a PHP question, but I'll answer.

update <tablename> set <columname> = <columnname> + 1

will work in most SQL database servers. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!

 

[hos2]

and not to forget
update <tablename> set <columname> = <columnname> + 1
where <key> = ID

otherwise all your links are incremented

 

[sleipnir214]

hos2:

Yep, I missed that. Want the best answers? Ask the best questions:

http://www.tuxedo.org/~esr/faqs/smart-questions.html

TANSTAAFL!