Databases and Images

[chris124]

I have an asp web page that allows a user to request textual information from an Access Database, the results of this request are then displayed on a second asp web page.

What I want to happen now is that a thumbnail image is also called from the results of the users request, this thumbnail image then needs to have a hyperlink associated with it so that the user can click on it and see the full size image.

I don't want to embed these images into the Access Database as there are quite a few.

Any suggestions?

[ADAM Web Design]

I run into this situation quite a bit, and here's what I do:

1) Create six fields in your textual information table: Picture, Picture_Width, Picture_Height, Thumbnail, Thumbnail_Width, Thumbnail_Height .

2) Put the corresponding values for each picture/thumb into those six fields in your table. Make sure you put the widths/heights in too. You'll need those so that your page won't take as long to render as it tries to figure out how big the pics are for you (it's better coding practice too!)

That's really all there is to it.

[chris124]

Thanks ADAMWebDesign, I'll give it a go.

[richkoi]

I make all my images the same size and then imbed some php into the site to display the images:

<a href="javascript:popUp('productpopup.php?CODE=<? echo $CODE; ?>')">

[img]images/thumbs/<? echo $CODE; ?>.jpg[/img]

</a>

Rich

[brian.mark]

I just read the image with ImageMagick and then figure the heights and widths. Sure beats getting a wrong value in the database, and it has a lot more flexibility than making them all the same size.

Brian.

[richkoi]

What is the need of defining the image width and height in the database? When coding it into the site you just leave the image height and width out of the code and it will automatically display to the image specs.

Rich

[brian.mark]

Originally Posted by richkoi

What is the need of defining the image width and height in the database? When coding it into the site you just leave the image height and width out of the code and it will automatically display to the image specs.

Rich

Height and width make pages render faster. Especially for those with dial-up. Broadband probably doesn't need it as much.

Brian.