Incrementing value in database.

[heldenbrau]

Is there a quick way to increment a value in a database.

 

I want to count how many times users go to certain pages.  So when somebody clicks the page, a php script connects to the database and adds 1 on to the number.  The only way I know how to do it is to connect to the database, search the table for this page and get the number of times it is viewed, then update the table.  So 2 queries, is there a way to do it in one?

[ManiacDan]

UPDATE `yourTable` SET `yourField` = `yourField` + 1 WHERE `someId` = 123;

-Dan

[heldenbrau]

Thanks, sorted.