theprofessional — Wed, 17 Apr 2002 13:59:41 +0000

Thanks Mark.

Mark Hensler — Tue, 16 Apr 2002 20:11:03 +0000

SQL:
UPDATE table_name SET field1=field1+1 WHERE field2='key'

theprofessional — Tue, 16 Apr 2002 15:04:06 +0000

I don't know if this will help but I'll give it a stab.

When a surfer clicks on the thumbnail of an image for instance to get the details, a variable is passed such as http://*.com?detail=view&image_id=image_id to tell the script to parse this block of code to show this information from the database.

Put in the code something like:
if(isset($detail)):
$sql="update thetable set count+1 where image_id='$image_id'";
mysql_query($sql);
endif;

The sql may be wrong but you get the idea. This is if there was a field in the image data called count. Now your count for clicks to view details are incremented.

galt — Mon, 15 Apr 2002 04:07:49 +0000

I don't think it is that hard, but it depends on your whole system. Rather than link directly to the image in a URL, you need to link to a "count and display" script that increments a counter in the database for the image, and THEN display the image. So your link looks like

Busy — Mon, 18 Mar 2002 08:22:48 +0000

Thanks, think I may have to rethink some of the options I want, getting way to involved and messy

mairving — Sun, 17 Mar 2002 18:57:45 +0000

If each page had a unique page_id, you could do it. It would be even easier to count the clicks if someone clicked on a thumbnail image. I have seen this code in gallery, a web based photo display. If you do store it in a database, the database would get to be pretty big after awhile, so that you would probably have to have a script to roll the data into another table.