database column view count

[jonki]

Hi - I was wondering if someone could help me.

I would like to have a column in my database that counts how often this particular row (or entry) has been viewed.

I am thinking something along the lines of - in the results page of my php file to have something like $count=$count++; insert into db count value $count ........ but I am not sure how to this exactly. I am not expecting anyone to write me any code but the name of specific functions or any ideas would be great.

I was wondering if there perhaps was some kind of feature already included in MySQL which would do this for me.

Basically - I want to show to the people who use my database how many people actually look at thier products (or at least how many times these product details are shown on screen) and present this to then.

As always I would be so grateful for any help.

Cheers

Jon

[LordShryku]

Well, the script to update it you'll have to do yourself, but the update SQL is fairly simple...

UPDATE table SET field = (field + 1);

[jonki]

Thanks - sounds easy enough, I'll give it a go.

Cheers.