increment (not auto) a db entry with SQL

Forum Moderators: open

Message Too Old, No Replies

easiest way?

8:13 pm on Aug 22, 2006 (gmt 0)

The following query doesn't do the trick:

UPDATE SET responses = responses + 1 WHERE ID = $ID

What should I use?

8:36 pm on Aug 22, 2006 (gmt 0)

pixeltierra,

It should be

UPDATE tablename SET responses = responses + 1 WHERE ID = $ID

Chad

4:51 am on Aug 23, 2006 (gmt 0)

You're right. Duh. Sometimes the simplest things go unnoticed!