incrementing a value in a field

[NDS Ltd]

Hi,

**newbie alert**

i want to update a value in a database.

i would normally read the value out of the database, assign to a variable,
then to $variable=$variable++ then use an update statement to set the new
value in the table..

is there an easier way to increase a fields value by one in a single query?

many thanks

sean

[Aggro]

NDS Ltd wrote:

i would normally read the value out of the database, assign to a variable,
then to $variable=$variable++ then use an update statement to set the new
value in the table..

is there an easier way to increase a fields value by one in a single query?

# for example like this:
update yourtablename set yourcolumnname=yourcolumnname+1 where id=1;

[NDS Ltd]

thanks mate that worked a treat!

--
Sean Browne
NDS Ltd / Connections
07971 175 354
"Aggro" <sp**********@yahoo.com> wrote in message
news:0x************@read3.inet.fi...

NDS Ltd wrote:

i would normally read the value out of the database, assign to a variable, then to $variable=$variable++ then use an update statement to set the new value in the table..

is there an easier way to increase a fields value by one in a single

query?
# for example like this:
update yourtablename set yourcolumnname=yourcolumnname+1 where id=1;