Posted by John McClumpha on 11/22/05 12:30

Thanks Rob - that's done the trick nicely :)

On 21 Nov 2005 04:38:20 -0800, 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)
>
>John McClumpha schreef:
>
>> Hi there - just a quick query (pardon the pun)...
>>
>> is there a simple (quick) way to increase the value of an integer
>> field in a nominated row by 1 other than first having to retrieve the
>> value and then UPDATE the appropriate field? - similar to doing a
>> $Variable++ in PHP?
--
John McClumpha
Darkness Reigns - http://www.incitegraphics.com.au/darkness/

• Next in forum: Re: increase MySQL field value by 1? (quickly/easily)
• Prev in forum: Re: HTTP_REFERER
• Thread view: Re: increase MySQL field value by 1? (quickly/easily)

[Reply to this message]