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

[Back to original message]