[thesoj]

I have a whole bunch of images, and I want to know how many times each have been viewed.

But the trick is, that I need to update a mysql db, with the info, say when someone accesses:
www.mysite.com/myimage.gif

I need to update it using a PHP script, but I don't know how I'd go about it.

I can't figure it out, I also tried to do it with a php script, like:
www.mysite.com/img.php?i=myimage.gif

But failed miserably at it.

Any help would be greatly appreciated.

Thanks

[NeverMind]

using a php script is the sulotion ..
something like that:

PHP Code:

<?PHP

$ID = (int)$_GET['ID'];



/* DO MySQL CONNECTION HERE */



$fetch = mysql_query("SELECT * FROM image_table WHERE ID='$ID'")or

die(mysql_error());



$num = mysql_num_rows($fetch);



if (empty($num))

   $fullname = 'path/to/default_error.png';

else {

   $images = mysql_fetch_assoc($fetch);



   $image = $images['imagename'];

   $path  = $images['imagepath'];



   $fullname = "$path/$image";



   mysql_query("UPDATE image_table SET counter=counter+1 WHERE ID='$ID'")or

   die(mysql_error());

}



$fp = fopen($fullname, 'r');

$read = fread($fp, filesize($fullname));

fclose($fp);

die($read);

?>

and to get the pictures use:

Code:

<img src="image.php?ID=25" alt"" />

or you could use the file name instead of the ID

[thesoj]

That just about did it, although I needed to change a few things.

Thank you very much.