[SOLVED] Updating a field every time a page is "Viewed"

[JSHINER]

How can I update the value of a table field each time a page is viewed? So if I set it to start at 0, when the page is called up it updates +1 to 1, then +1 to 2, etc.

 

 

[php_dave]

Not sure I understand what you are asking for but the below Query will increment a field everytime it is called

 

UPDATE tablename SET fieldname = fieldname + 1;

 

That what you meant?

 

 

[JSHINER]

Yes exactly - now how can I get this to work?

//$db->query("UPDATE tablename WHERE id = $id SET fieldname = fieldname + 1");

 

 

[JSHINER]

Never-mind got it. Thanks!