Auto Incriment per hit

[Anon]

How can I get a number to auto incriment per hit based on different users -- but then at a certain number (say 5) go back to 1 again.

OK. I am wanting to do something like rand() but, in my order, based on each "refresh".

Thanks for any help you can provide!
Josh

[brandonschnell]

you can do this using sql.

UPDATE clickdata SET hits = (IF(hits<5, hits+1,1)) WHERE user = 'bob'