Hit Counter

[Anthony_john5]

For the Ecards system on my website I was interested in counting the number of views each card gets. I know that I can easily do this with two queries. The first getting the current number of hits and the second updating it to an incrmented variable.

However I was wondering if with MYSQL it is possible to use a single query, perhaps one which increments values?

• Anthony

[csousley]

without testing it myself try this:

$query = "update table set value = (value + 1) where id = whatever";