Can MySQL be used to create a 'hit-counter' on a web site?

[bluebox39]

Is it possible to have a hit counter on a web site powered by MySQL database. How is this possible? Thanks

[Hartmann]

Sure it can. The design of it just depends on what kind of information you are wanting to capture. If you just want to get the total number of hits on your website then you could have a table with just 1 column and 1 row:

create table counter (
hits int(7) not null
)

Then in your PHP you would check to see that a person is visiting for the first time and update the number in that field by 1.