image update problem

[littleelmo]

Hi,

I'm getting this weird behavior with updates into a mysql database with binary data (images)

It's obviously a web-based form-based update and the update into the table of the new form field data is occuring succesesfully.

The problem is when I go check to see that the image has in fact been changed, the original image is being displayed. Only if I press the reload button on the browser does the updated image display.

I don't know why this is happening but if anyone has any ideas on what I'm doing wrong, I'm all ears.

here's a snippit of relevant code.

$type = $fupload_type; //set image type
$size = $fupload_size; //set image size
$bin_data = addslashes(fread(fopen($fupload, "r"), $size));

$query = "UPDATE image SET caption = '$caption', title = '$title', picture = '$bin_data', picture_type = '$type' person_id = '$person_id' WHERE image_id = '$image_id'";
$result = mysql_query($query);

[noeffred]

I'm not sure about this but it appears like a problem with the browser. The image is probably just located in the cache of the browser app. i'm seeing this quite often using IE, hitting F5 (reload) seems to correct the problem.

[littleelmo]

I'm using netscape. I'm wondering if it's not so much browser specific than it is some tweek needed in the php.ini file?

[Anon]

I agree with Christian, I'm thinking it is a cache problem rather than a php problem. Try this, change this setting:
"Document in cache is compared to document on network:" to Every time, see if that alleviates your problem. Also, are you recalling your page or are you using the back button? I think the setting I mentioned above should solve your problem.