|
|
Posted by Rik on 11/22/05 13:12
Stefan Rybacki wrote:
> rob@centralpoint.nl wrote:
>> Sure, increase it in the update query, example:
>> UPDATE hit SET counter+1 WHERE site='www.google.com'
>> (assuming that counter field is integer)
>
> Well, should be:
> UPDATE hit SET counter=counter+1 WHERE site='www.google.com'
>
Hmmz would this work?
UPDATE hit SET counter=counter+1 WHERE counter > 5
I have no way to test this quickly right now, but it would save a lot of
lines of code :-)
It's for a table displayed in a specific order, and order has te be
changeable.
Grtz,
Rik
Navigation:
[Reply to this message]
|