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

On Mon, 21 Nov 2005 16:45:34 -0500, Pat Farrell <pfarrell@nospam.com>
wrote:

>John McClumpha wrote:
>> 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?
>
>Why not use the autoincrement feature of MySql?

because it won't do what I am after....

I'm using autoincrement on one field in that table (ID) - which is
serving the purpose well (i.e. when a new record is added it obtains
the next available integer for the ID field)... however what I am
wanting to do here is update a field and increase its value within an
existing record by 1

--
John McClumpha
Darkness Reigns - http://www.incitegraphics.com.au/darkness/

[Back to original message]