mySql updating numbers

[Mikey P]

Hi, sorry to double post. I also need some direction on how to update
mysql correctly when someone clicks a link it adds 1 to the database,
if someone clicks again it ads 1 which = 2 hits. What's the proper way
of doing this. Thanks again! - Mikey P.

[Kevin]

Re: mySql updating numbers

If I understand your question, you're looking for something like this:

UPDATE `my_table` SET hits = hits + 1 WHERE record_id = '$id'

Obviously you'll need to change the variable names to match your table, but
the point is you can use a column's current value in an update.

- Kevin

"Mikey P" <phatnugs420@co mcast.net> wrote in message
news:1127142562 .098174.249550@ f14g2000cwb.goo glegroups.com.. .[color=blue]
> Hi, sorry to double post. I also need some direction on how to update
> mysql correctly when someone clicks a link it adds 1 to the database,
> if someone clicks again it ads 1 which = 2 hits. What's the proper way
> of doing this. Thanks again! - Mikey P.
>[/color]