Images in MySQL and PHP

[saltwater]

I am using MySQL to store an amount of images, when I request these images in a page with an external script
( like this: <img src="img.php?id=1&view=admin">),
sometimes, the browser (netscapes aswel as internet explorer) doenst show the image (probably because it isn't downloaded), maybe the script that outputs the image has exceeded the maximum execution time of 30 seconds, or could this be a MySQL problem? or something else?

All help would be really appreciated!

Regards,
Bruno

[sahammondsr]

Bruno,

Ultimately, tracking down this error would require more information on how the image is being stored into MySQL, how its being selected out, and how img.php is sending the data back out to the browser. (Are you storing the actual binary or simply a file name reference?)

Unless you have a huge MySQL database, I can't imagine the query itself exceeding the 30 second execution limit typically in place in most PHP implementations. (What size is your overall database?).

Scott A. Hammond, Sr.
http://www.primainternet.com

[saltwater]

First of all, thanks for replying 🙂

I am actually storing the binary data in my database, and the script (img.php) resizes the image dependently on $view (so people can't screw arround 🙂, the database itself is not so big, every record can contain 3 images, (there are 3 coloms with BLOB as datatype).
The user can choose to upload none, one, 2 or 3 images.
On the page where the problem occurs, there are multiple images who use the script, also, when i resize the images to 20 x 20, there is no error, but on the page where i resize them to 50 x 50, sometimes, there is a problem, the images are not bigger than 15 K

Hope you understand me correctly 😉
Thanks in advance,
Bruno