img src="pic.php?picnr=1423"

[danieloberg]

I want to use something like:

<img src="pic.php?picnr=1423">

below is the file pic.php

<?

mysql_query( "UPDATE pictable SET views=views+1 WHERE picnr='$picnr'" ) or error( mysql_error() );

echo "<IMG SRC=\"$picnr.jpg\">"; // what should I write here?

?>

Thanks!

// Daniel

[AstroTeg]

I think I see where you're going...

You're trying to log in a database any views of an image. But as you're noticing, the image isn't being displayed properly.

What you'll need to do is persuade PHP to read the contents of the desired image and feed it back to the browser.

Something like:

header('Content-type: image/jpeg');
readfile($NameOfDesiredImage);

Untested, but I think that will work. You'll need to remember change the content type based on the format of the image.

[rrijnders]

...and you will probably need to use the absolute path and file name in the readfile() function.