[RESOLVED] SQL: add/increment a value w/o two queries?

[Chris_96_WS6]

Maybe I'm not searching for the right thing but couldn't find any existing threads on this.

Say I have a counter field in a table. Call it $Count.

Then, suppose a function is executed, and part of it is to add 1 to $Count.

Right now I'm doing two queries, one to select $Count, and then one to update $Count to the new value once I've done $Count++;

Question: Is there a way to write the SQL statement to add to Count in one query?

Something like?

UPDATE table SET Count+1 WHERE ID='$ID'

[Lars_Berg]

update t set count = count + 1 where .. 

[Chris_96_WS6]

Perfect, thanks!

That actually looks familiar....perhaps something I used once and forgot a time ago.

[laserlight]

Remember to mark this thread as resolved (if it is) using the thread tools.